Okay this is my situtation, i am using Dreamweaver CS5 and SQL 2008. I am trying to create a connection string to my database server but i cant establish the connectio because it tries to log me in as a different user. This is a simple connection i am trying to make to test my server.
string connectionString = "Data Source=MYSERVER; Initial Catalog=MYDB; Integrated Security=SSPI";
SqlConnection con = new SqlConnection(connectionString);
lblInfo.Text = "Connection Is: " + con.State.ToString();
lblInfo.Text = "Error reading the database " + err.Message'
lblInfo.Text = "Now Connection is " + con.State.ToString();
So Then end result is that i get the error message "Login failed for user something" Now Connection Is Closed.
Where something is the name of my web server, so its trying to connect to my sql db as the web server and not me, i dot know how to fix this. The db has users with permissions that will be able to read and write to the db so i just need windows authentication, this will then grab the name of the user and establish a connection to the db. So basically iam using SQL as my backend and asp.net (dreamweaver)
View Complete Post