View Single Post
  #2 (permalink)  
Old April 7th, 2007, 03:21 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

Where does the SA user name and password come from? What makes you think this all of a sudden works? That is, the fact you're using these details must mean you configure an account like that somewhere?

You may want to take a look here for more details about connecting to SQL Server: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

I think the most likeliest thing to do is change "(local)\SQLExpress" to the name of your remote SQL Server.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.