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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to use Sql server in Limited Window user Account

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-16 : 07:17:25
Ankush Jain writes "I m using Sql Server 2000 in Windoes XP (SP2) with Limited Window Account.
I m new to Sql Server.Please You can tell me how to create database.
When i expand the console root in Enterprise Manager it will show an error : "A connection could not be established to Local""

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-16 : 07:28:22
1) There is no local database
2) The local database is not started
3) You have not permission to access the local database


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-10-17 : 01:36:20
to connect to the database:

1. do you have permission to connect to the database? what type of login? windows or sql authenticated?
2. do you know where the database is located?
3. have you registered the server or instance name in enterprise manager? do you need to define the connection in the client network utility (under program files\microsoft sql server)?

HTH

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -