my company use SQL server2000 I use vb.net2003
Last week My web on intranet worked but
Today we have a new server and move the data to another server
my old connection string is "user id=sa;password=;datasource=server1;initail catalog=table1;"
Now I have changed only datasource to "user id=sa;password=;datasource=server2;initail catalog=table1;"
I am not sure about the user id(that the admin told me) because when I test my web it show error message like this
******************
Login failed for user 'sa'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'.
*******************
(and I have tried user ID= blank too)
How can I know the user id of the server (SQL server 2000)?
Thanks for helping me
Have a nice dayTwo things.
First, you give wrong information. Your connectionstrings are not valid. It is NOT spelled "initiail catalog".
Second, what about the SA user? It looks simply like you give the wrong password. That simple. Try entering the correct password. Try resetting the password.|||YEs,I mean "initial catalog"--> not in case 1
the old one worked.I think the problem is only --> I don't know The user ID and password.
For case 2--> I can create and update (edit , delete) the table in SQL database.but I don't know well how to manage the SQL server I am just the user who can design DB and create tables in DB.So now I don't know both of user ID and password.
I think 1.ask the db administrator-->but he's on vacation.
2.Can I know by searching in SQL Enterprise Manager or something like that?
thanks for helping me.
Have a nice day.|||A web database developer huh?
Case 1: owned
Case 2: owned
Case 3: owned
You're using the 'sa' account? That's foul! Create a user specifically for the site, and give it permissions based on the databases and tables you need. Also.. initial catalog isn't a table. It's a database name.|||YEs initial catalog is my db name.The problem is-> I am not admin,I just want USER ID and Password For accessing DB (via my web page).
For the old server I used SA and blank password,I know these from admin but for the new one I don't know both of them I have tried "SA" and PAssword SA or blank oe something like that it show the error message -->Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
or-->Login failed for user 'SA'
so I want to know how can I get the sql user id and password?
(I cannot right click at the server for see the property of the server)
Or I cannot do anything.
Thanks a lot for helping me.
Have a nice day.
