Many Thanks

I have 2 xp machines one has the SQL EXPRESS Server with all the goodies on it and the other I just install the client stuff. I am using VB 6 to program with using the ADO. It works great on the server machine. The software pulls up great. I can't seem to get it to work on the client machine. I get "Login failed for user 'TIGGERL\Guest'. I found the places to set the TCPIP setings on the server SQL Express to allow this even turned on the browser but nothing same error. I am using the same login on both machines and am pointed to the same workgroup. I used window authentication when I set them up. Not sure why it insists on using Guest.

This is a copy of the connection string I am using

"Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;AttachDBFileName="c:\mpsdb\mpswarehouse.mdf;Database=MPSDB;Data Source=tiggerl\sqlexpress;Trusted_Connection=yes;"

Not sure if this is okay for connecting remote. Any help would be greatly appreciated

Rick

Hi,

Using guest normally means that you enabled the "Simple filesharing" on your computer which will not prompt the user for credentials rather than using the standard user (Guest).
Try to switch that and let see if that helps:

Explorer > Tools > Folder Options > View > Enabled simple file sharing
HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Many thanks, thats all it was, just for fun I even tried it on Vista it works great there to.

Thanks