| Author |
 Topic Search  Topic Options
|
Mart 
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 06 August 2003 at 2:42am |
Ok ignore that last post, I have got SQL Server Manager working and asp.net webmatrix has found the server. But I can't create databases or anything because it says I have the wrong username, what is the default username for SQL Server? And how do I change it?
Thanks, Mart
|
 |
bsandell
Newbie
Joined: 19 August 2003
Location: United States
Status: Offline
Points: 1
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 August 2003 at 7:59pm |
Hi Mart,
Log in as user "sa" (without the quotes) using the password you specified as SAPWD when you did your install.
To connect from the command line, you would type
osql -Usa -P*****
this should log you into the master database of the default server. You can create your new databases from here or use a third party tool.
Bruce
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 August 2003 at 3:54am |
hmm that doesn't seem to work either, this is the error i get from the commmand line Login failed for user 'sa'. Reason: Not associated with a trusted sql server connection.
How do I acociated trusted connections?
Thanks, Mart.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 August 2003 at 7:16am |
Go to regedit then
HKEY_Local_Machine>Microsoft>MSSSQLServer>MSSSQLServer> and change the Value for LoginMode to 2 this will change you SQL to be in Mixed mode. Gotta restart the service though. After that you will be able to login with sa as described above.
|
|
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 August 2003 at 7:08am |
Thanks michael i can login now, i have created a database using the ASP.NET Web Matrix wizard but I don't know how to make tables. I Tried creating a DSN for it and exporting my old access db into it but it hasn't come up. How do I edit databases and tables etc.
Thanks, Mart.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 August 2003 at 10:55am |
|
You should download some Management tool if you don't have Enterprise Manager. There are a few web based ones on aspin.com or do a search on cnet for a win app
|
|
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 3:20am |
Thanks michael im using this one http://www.webattack.com/get/dbamgr2.shtml if anyone else needs one. This is the final question then im sorted  . Could someone connect to my server get in with username 'sa' and no password (I tried it with no password and it works!). If so how can I put a password on the 'sa' account?
Thanks, Mart.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 7:05pm |
|
Run a SQL Query like
sp_password NULL, 'newpassword', 'sa'
|
|
|
|
