connect sql 2005 using standard security
-
how to use standard security connection string to connect sql 2005.
-
how to use standard security connection string to connect sql 2005.
Do you mean SQL Server authentication or Windows authentication? Be more specific in your request and provide a bit more information so we can help you.
...Steve1. quod erat demonstrandum 2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once :-) -
Do you mean SQL Server authentication or Windows authentication? Be more specific in your request and provide a bit more information so we can help you.
...Steve1. quod erat demonstrandum 2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once :-)i want to use sql authentication.i created a new user account with sql mangement studio.but i can't connect using it with sql authentication. i use same username and password on my coding. getConnectionString_local = "Server=Z1\SQLEXPRESS;Database=" & DBPath & "test;User ID=amilapradeep;Password=amilapradeep;Trusted_Connection=False" it's this then it gives error as "Login failed for user 'amilapradeep'. The user is not associated with a trusted SQL Server connection." but i can connect using "attach db" method it's connecting
-
Do you mean SQL Server authentication or Windows authentication? Be more specific in your request and provide a bit more information so we can help you.
...Steve1. quod erat demonstrandum 2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once :-)ok i got the anwser.i had not specified as mix authentication on sql server, thanks