开发者

Windows server 2003 problem connection to remote sql server

开发者 https://www.devze.com 2023-02-21 22:06 出处:网络
I have this connection string: Driver={SQL Server}; Server=XX.XXX.XX.XXX; Database={databasename}; Uid={username}; Pwd={password};

I have this connection string:

Driver={SQL Server}; Server=XX.XXX.XX.XXX; Database={databasename}; Uid={username}; Pwd={password};

I have even tried

Driver={SQL Server}; Server=XX.XXX.XX.XXX; Database={databasename}; Data Provider = SQLOLEDB; NETWORK LIBRARY = DBMSSO开发者_运维知识库CN; Uid={username}; Pwd={password};

but i get

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

what is the solution? i read on msdn and microsoft and accross the web but couldn't fix it. i don't have access to the sql server, it belong to another company that give me the mailing list service.

from my home computer (windows 7) i can connect with anything i try but from the server it is not working

0

精彩评论

暂无评论...
验证码 换一张
取 消