RE: Discovering SQL Server instances in Server Explorer
From: Cameron Slade [MSFT] (camsl_at_online.microsoft.com)
Date: 07/22/04
- Previous message: hk: "Custom Event Sinks that extends the Microsoft Logging Block Application"
- In reply to: TravisL: "Discovering SQL Server instances in Server Explorer"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 19:29:48 GMT
Hi Travis,
You should be able to accomplish what you are trying to do by running the following script while connected as a DB admin to the instance of MSDE. Remember to replace <machine name> with
the name of the machine hosting MSDE.
if not exists (select * from master.dbo.syslogins where loginname = N'<machine name>\VS Developers')
exec sp_grantlogin N'<machine name>\VS Developers'
exec sp_defaultdb N'<machine name>\VS Developers', N'master'
exec sp_defaultlanguage N'<machine name>\VS Developers', N'us_english'
GO
exec sp_addsrvrolemember N'CAMSL-PENPC\VS Developers', sysadmin
GO
--------------------
>Thread-Topic: Discovering SQL Server instances in Server Explorer
>thread-index: AcRvWYjtb4xMCxu4Sfe9bw7yWD/tTA==
>X-WBNR-Posting-Host: 209.12.55.48
>From: "=?Utf-8?B?VHJhdmlzTA==?=" <TravisL@discussions.microsoft.com>
>Subject: Discovering SQL Server instances in Server Explorer
>Date: Wed, 21 Jul 2004 12:33:01 -0700
>Lines: 6
>Message-ID: <AC0EA164-7E94-48E8-9546-8E9DDCA21695@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.vsnet.enterprise.tools
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.157
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.vsnet.enterprise.tools:2546
>X-Tomcat-NG: microsoft.public.vsnet.enterprise.tools
>
>I am a deveoper using Visual Studio and an MSDE database located on a network server. My user account is not a member of 'Administrators' or 'Domain Admins', but is a member of
'Debugger Users' and 'VS Developers'. When I use the Server Explorer in Visual Studio and expand 'SQL Servers' on the Server that hosts the MSDE database I get an error message that
states:
>
>Could not automatically discover any SQL Server instances.
>Choose Register SQL Server Instance from the shortcut menu if you know there are SQL Server instances on this machine.
>
>I tried that using the name of the SQL Server Instance and I eventually get the SQL Server Login prompt. I have tried granting my user account database access using sp_grantlogin,
sp_grantdbaccess, and the Web Data Administrator. I can remote desktop to the server hosting MSDE and use the OSQL utility without a problem. What I would like to do, is give members of
'VS Developers' the same access on the SQL server as local Administrators have.
>
Cameron Slade
Microsoft VSData Team
http://blogs.msdn.com/vsdata
-- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
- Previous message: hk: "Custom Event Sinks that extends the Microsoft Logging Block Application"
- In reply to: TravisL: "Discovering SQL Server instances in Server Explorer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
