Hello

I have vista and I upgraded MSDE to Express and now SQL Studio won't let me
connect to MMSSD with windows authentication.

What are my options?

Thank You

I feel that the SQL Server Browser service is not running on your SQL Server
express machibe. If you start it, then
you may be able to connect.

As well as using SQL Server Surface Area configuration select remote
connections options for Local and remote connections.

Thanks
Hari


[quoted text, click to view]

By default, users on Windows Vista that are members of the Windows
Administrators group are not automatically granted permission to connect to
SQL Server, and they are not automatically granted SQL Server administrator
privileges.
To add a Windows user that has the login "domainname \username" to the
sysadmin fixed server role
1. Log on to the computer using the credentials for the domainname\username
account.
2. Click the Start button, point to All Programs, click Microsoft SQL Server
2005, right-click SQL Server Management Studio, and then click Run as
administrator.
3. In the User Access Control dialog box, click Continue.
4. In SQL Server Management Studio, connect to an instance of SQL Server.
5. Click Security, right-click Logins, and then click New Login.
6. In the Login name box, enter the user name.
7. In the Select a page pane, click Server Roles, select the sysadmin check
box, and then click OK.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]