SSEUtil RTM version is now available (by yag)

Comments

# Roger Jennings said on November 5, 2005 7:10 PM:

SSEUtil.exe isn't working as advertised for me with a default SQLS 2005 instance and SQLEXPRESS named instance on a test partition, logged on to Windows Server 2003 as Administrator. SharedMemory, TCP/IP and Named Pipes are enabled for both instances and the clinet.

SSEUtil -listsrv returns
OAKLEAF-MS15\SQLEXPRESS (Network Service)
OAKLEAF-MS15 (Local System)

I have AdventureWorks (OLAP) and Northwind installed on botht the default and SQLEXPRESS (both instances behave normally with SSMS).

SSEUtil -l [.\SQLEXRESS] returns
1. master
2. tempdb
3. model
4. msdb

AdventureWorks and Northwind are missing from the list. Does the -l switch support only attached databases?

SSEUtil -s {OAKLEAF-MS15 | .} -l returns a
"The user instance login flag is not supported on this version of SQL Server." or "A connection was successfully established with the server but an error occured during the login process (... shared memory provider ... No process is on the other end of the pipe.)

Thanks in advance,

--rj

# Antoine Cote [MS] said on November 14, 2005 12:50 PM:

Hello Roger,

I guess the reason you're not seeing your databases listed is that SSE supports two types of instances: (1) Main instance and (2) Per-user instance. By default, SSEUtil works against the user instance. If you want to work against the main instance, you need to use the -m switch. For example: SSEUtil.exe -l -m

HTH

Antoine
Visual Studio .NET team.

Leave a Comment

Name (required) 

Your URL (optional)

Comments (required) 

  

Enter Code Here: Required

Remember Me?

About YAG