Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krishna_yess
Yak Posting Veteran
81 Posts |
 Posted - 2008-10-21 : 09:36:39
|
| I have installed SQL Sever 2005. Every time i open it i need to select "Windows Authentication" option.i don't have any user ID and PasswordHow can i create a login thanksKrishna |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-21 : 10:10:59
|
| Did you enable Mixed mode authentication in server properties? |
 |
|
|
krishna_yess
Yak Posting Veteran
81 Posts |
Posted - 2008-10-21 : 10:24:00
|
| Thanks. i solved that prob. now i have some other prob.error message"CREATE DATABASE permission denied in mster"some help |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-21 : 10:25:01
|
| User doesn't have permission to create database. |
|
|
|
krishna_yess
Yak Posting Veteran
81 Posts |
Posted - 2008-10-21 : 10:27:05
|
| then how can i create a database.the sql server is in my pc. |
|
|
|
krishna_yess
Yak Posting Veteran
81 Posts |
Posted - 2008-10-21 : 10:32:27
|
| I got it..i had to give permissions |
|
|
|
|
|
|
How to create a sql server authentication