Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange experience in SQL 2008 when connecting
Message
From
28/06/2009 17:15:32
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Strange experience in SQL 2008 when connecting
Environment versions
Application:
Desktop
Miscellaneous
Thread ID:
01408945
Message ID:
01408945
Views:
244
I have SQL 2008 installed in a instance called: 'SQL10'

IF I use this connection string all workks fine
cStringConnect =("Driver={SQL Server Native Client 10.0}; Server=BOSS2000\SQL10; UID=sa; PWD=zqtzip1ploc; Database=AdventureWorks; Network Library=DBMSSOCN")
nID = SQLStringConnect(cStringConnect)
?nid
But if I try to connect using this string, it fails
cStringConnect =("Driver={SQL Server Native Client 10.0};SERVER=192.168.1.2\SQL10; Address=192.168.1.2,1433; UID=sa; PWD=zqtzip1ploc; DATABASE=AdventureWorks")
nID = SQLStringConnect(cStringConnect)
?nid
Returns this error message:
---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '08004'
SQL Server Error: 4060
Server rejected the connection; Access to selected database has been denied

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sa'.

Why if I can connect to the database in the first connection string?
Returns the same error when I remove the \SQL10 when I try to connect using IP
Any advice:?

TIA

Peter
Next
Reply
Map
View

Click here to load this message in the networking platform