Problem with SQL Server connection string.

[venkatanarasimhaa]

Hi,

I am developing one application in VB as front end and SQL Server as backend. When I am trying to connect to SQL server, If I have Local Admin rights to my system then it is working fine otherwise If I dont have Local Admin Rights to my system, it is not working. How can I connect to Server without having local admin rights?

If you can send me sampl connection string, that would be grate.

Thanks in advance for your reply.


Regards,
Venkat.

[daniel aristidou]

Hi,

I am developing one application in VB as front end and SQL Server as backend. When I am trying to connect to SQL server, If I have Local Admin rights to my system then it is working fine otherwise If I dont have Local Admin Rights to my system, it is not working. How can I connect to Server without having local admin rights?

If you can send me sampl connection string, that would be grate.

Thanks in advance for your reply.


Regards,
Venkat.

Try changing the sql settings

[QVeen72]

Hi,

Create a Public User in SQL Serve, and assign access rights to the Required database. use this userID/password in the connection string

Regards
Veena

[jamesd0142]

I created a user in SQL2000 called QueryTool and assigned access rights as required, then i use the following connection string successfully...

[code=text]
Con = New OleDb.OleDbConn ection("Provide r=sqloledb;Data Source=server;I nitial catalog=databas e;ID=QueryTool; Password=MYPASS ;connect timeout=0")
[/code]