Error » Microsoft Error! » Microsoft Operating Systems Error » Microsoft windows vista error » Need to access SQL database that is running on a Vista machine from other machines.

Microsoft windows vista error all errors related to microsoft windows vista

Post New Thread Reply
  Need to access SQL database that is running on a Vista machine from other machines.
LinkBack Thread Tools Display Modes
Old 20-Apr-2007, 02:39 AM   #1 (permalink)
Administrator
 
Anilrgowda's Avatar

Posts: 18,720
Join Date: Jan 2006
Rep Power: 10 Anilrgowda is on a distinguished road

IM:
Default Need to access SQL database that is running on a Vista machine from other machines.

Question: Vista Buisness 64 bit edition
SQL Server 2005 Developer edition with SP2

I cannot connect to the database in SQL. I can see it in analyzer, I just can't access it. I get an access denied every time I try to get into it. It is on the same domain and segment so it shouldn't have anything to do with routing or firewalls. I have tried adding the domain user account as an administrator on the Vista machine and adding it to the SQL server accounts as well. I have the windows firewall turned off. I tried disabling UAP. For some reason port 1433 is still being blocked by something. Please help.
Anilrgowda is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit!
Reply With Quote
   


   
Old 20-Apr-2007, 02:39 AM   #2 (permalink)
Administrator
 
Anilrgowda's Avatar

Posts: 18,720
Join Date: Jan 2006
Rep Power: 10 Anilrgowda is on a distinguished road

IM:
Default Re: Need to access SQL database that is running on a Vista machine from other machine

This may be too basic, but by default TCP/IP is not enabled in SQL Server 2005. Open SQL Server Configuration Manager and verify that SQL Server is listening on TCP/IP. If it is not then enable it and restart SQL Server.
Anilrgowda is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit!
Reply With Quote
Post New Thread Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT -8. The time now is 09:26 PM.

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0

DMCA Policy

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228