Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slimjen
Yak Posting Veteran
61 Posts |
 Posted - 2007-07-17 : 11:33:45
|
| All, I have SQL 2005 on a virtual server. I have an access frontend and SQL backend. I need users to test the database I am working on. I gave the permissions to access the database. Now, I am trying to set up the odbc connection but I get an error:Connection Failed:SQLSTATE: '01000'SQL Server Error: 233[Microsoft] [ODBC SQL server driver][DBNETLIB]Connection open (PreLoginHandshake())Connection failed:SQLState: '08001'SQL Server error: 11[Microsoft] [ODBC SQL server driver][DBNETLIB]General Network error. Chcek your network documentationIs there something am missing because this is a virtual server? Is it considered a remote connection and I need to do something else that am not aware of? Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-17 : 13:06:37
|
| Did you specify correct sql instance name in dn? |
 |
|
|
slimjen
Yak Posting Veteran
61 Posts |
Posted - 2007-07-17 : 14:00:12
|
| Yes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-17 : 23:03:48
|
| Ensure sql2k5 allows remote connection, sql server browser service is running on the server, tcp/ip protocol is enabled, you used correct port number in dsn. |
|
|
|
|
|
|
odbc error