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