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 |
|
nitinbljoshi
Starting Member
3 Posts |
 Posted - 2009-08-10 : 13:12:01
|
| Hi Friends,I have installed SQL Server 2005 on One of the machine on my LAN and on all other machines Visual Studio 2005 is Installed with SQL Express.In all Machines When we open visual studio and go to server explorer, SQL Server is Visible together with SQL Express but when I want to select database from list, databases are not available in the list.....I don't know what is the cause of this problem but may be incorrect installation or incorrect configuration of SQL Sever...Please help me.-- Thanks & Regards --Nitin Joshi---------------------- |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-10 : 14:32:45
|
| make sure clients have permission |
 |
|
|
nitinbljoshi
Starting Member
3 Posts |
Posted - 2009-08-11 : 10:26:18
|
| I have installed SQL Server on Workgroup and I Don't Know how to give permissions to client to access Server. Please tell me how can I give permissions to client so that client can access Server.-- Thanks & Regards --Nitin Joshi---------------------- |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-08-11 : 14:35:50
|
| Use enterprise manager and go to the security section under management.Unfortunately I dont have the options memorized. But you can find detailed information in SQL books online.This will get you in the right direction.http://msdn.microsoft.com/en-us/library/ms187648(SQL.90).aspx |
|
|
|
nitinbljoshi
Starting Member
3 Posts |
Posted - 2009-08-12 : 00:57:41
|
| I don't have Enterprise Manager in my SQL Server Program Menu.I have Configuration Manager, Surface Area Manager, Management Studio, and others.-- Thanks & Regards --Nitin Joshi---------------------- |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-08-12 : 10:55:07
|
| Management Studio is the replacement for Enterprise manager. |
|
|
|
|
|
|
SQL Server is Not Accessible From Client