Need help with sql server

[ryanlum]

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?

[mendhak]

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.

Get your connection string here:

http://www.able-consulting.com/ado_conn.htm

[The Cheat]

People usually leave the password blank.

Not smart and or paranoid people.

[ryanlum]

is there anyway of changing the password?

[mendhak]

Not smart and or paranoid people.

If we were smart or paranoid, we wouldn't be here.

[mendhak]

is there anyway of changing the password?

From that I assume you don't know what the original password is.

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.