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 |
|
soulkeeper
Starting Member
3 Posts |
 Posted - 2009-05-14 : 17:52:34
|
| Greetings .I am using SQL Server enterprise , im not a pro , im just an IT technical and something went wrong with the server and i had to install it again ( 2003 enterprise windows server ) then i installed SQL enterprise 2005 fresh install , what i did is during the installation they asked me if i want to use a local sql pass or an NT authorized pass and user so i chosed the NT to get the built in administrator and pass from active directory . the installation went fine , all services started well succsefully .the problem is on other pcs when i try to like to the server i can see it but i cant pick a database they say i dont have permession or server doesnt exist .i know i have to add a permession somewhere , can u tell me plz by step by step even if its hard i know but i will appreciate it .Plz help .. |
|
|
soulkeeper
Starting Member
3 Posts |
Posted - 2009-05-14 : 18:24:14
|
| and the error iam getting is 15247 . |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-15 : 00:01:22
|
| Sql Server should be running on domain account . |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-05-15 : 01:12:10
|
| Run the sys.login_token to find the types of permessions you have got. |
|
|
|
soulkeeper
Starting Member
3 Posts |
Posted - 2009-05-15 : 11:28:46
|
| Yes i am runing it on a domain account , and i am using the admin credentials , i was wondering if i should apply first a user name and a permession somewhere ... can u guide me ? plz ? |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-05-15 : 16:52:38
|
| Install SQL Server books online. There will be fully documented instructions for adding users to the security Section of SQL server.YOu will only beable to use active directory Users if all users are part of said domain and are also added as users in the security section of sql, and finally added to the database with the correct permissions. |
|
|
|
|
|
|
SQL problem