hey guyz...
when i am using vb net.. i can't get past this coding
myConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=pubs")
where can i find the password for the sa? and what do i put for the database?
Printable View
hey guyz...
when i am using vb net.. i can't get past this coding
myConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=pubs")
where can i find the password for the sa? and what do i put for the database?
Server should be (local) and you should know what the password is if you set it up. If you didn't, ask your administrator. People usually leave the password blank.Quote:
Originally Posted by ryanlum
Get your connection string here:
http://www.able-consulting.com/ado_conn.htm
Not smart and or paranoid people. :eek:Quote:
People usually leave the password blank.
is there anyway of changing the password?
If we were smart or paranoid, we wouldn't be here. :afrog:Quote:
Originally Posted by The Cheat
From that I assume you don't know what the original password is.Quote:
Originally Posted by ryanlum
Quote:
To reset the sa password:
1. Login to the SQL Server box as the Administrator.
2. Run SQL Server Enterprise Manager.
3. Right-click the server name and choose 'Edit SQL Server Registration properties'.
4. Choose 'Use Windows authentication' and click OK button.
5. Expand a server, expand a Security and click Logins.
6. Double-click the sa login and specify new password on the General tab.