Hello

i had a little connection funtion that I could run from either vb or Access that would allow me to connect to our SQL Server 2000 with a trusted connection.
when we upsized to SQL Server 2005 Express I managed to adapt this, but I am having real problems with SQL Servr 2008.

The database is stored locally on the server, but I think our systems guy has set it up with sql Security instead of both, so now I have to add the sa password to my connection string. This isn't a problem as I have the sa password, but when I am running my function, it still seems to be using my normal network login and not the sa password i put in.

This is the code I am using

Dim cnn As ADODB.connection
Set cnn = New ADODB.connection
cnn.Open "Driver={SQL Server};Server=SQL-MAYTAS;Database=CRT1174;User ID=sa;Password=xxxx;Trusted_Connection=False;"

I would appreciate any help, I am really stuck on this
Thank You

Please check the following link for usage of connections strings for SQL 2008
http://www.connectionstrings.com/sql-server-2008

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

I have, and as far as I can see my connection string is the same as in the heading Standard Security alternative syntax :

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connecti on=False;

However, even thought I am putting a username of sa and the password of xxxx, its till looking for my domain name. rather than logging on a sa

I've sorted it, it was becasue i had use trusted connection on the end.