December 25, 2011 at 8:41 pm
Hi Friends,
I am trying to start sql server and while starting i wanted users to connect using "sqlcmd" application and not other tools or applications.For that i have used following syntax. sql started successfully. However , while trying to make a connection, it is failing. Can anyone help me out.
Thanks in Advance.
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn>sqlservr.exe -sSQLEXPRESS -m"sqlcmd"
2011-12-26 09:02:56.07 Server Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
Mar 29 2009 10:27:29
Copyright (c) 1988-2008 Microsoft Corporation
Express Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
2011-12-26 09:02:56.07 Server (c) 2005 Microsoft Corporation.
2011-12-26 09:02:56.07 Server All rights reserved.
2011-12-26 09:02:56.07 Server Server process ID is 824.
2011-12-26 09:02:56.07 Server Authentication mode is MIXED.
2011-12-26 09:02:56.07 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2011-12-26 09:02:56.08 Server This instance of SQL Server last reported using a process ID of 1924 at 12/26/2011 9:02:41 AM (local) 12/
26/2011 3:32:41 AM (UTC). This is an informational message only; no user action is required.
2011-12-26 09:02:56.08 Server Registry startup parameters:
-d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
-e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
-l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2011-12-26 09:02:56.08 Server Command Line Startup Parameters:
-s SQLEXPRESS
-m sqlcmd
2011-12-26 09:02:56.12 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user actio
n is required.
2011-12-26 09:02:56.14 Server Detected 2 CPUs. This is an informational message; no user action is required.
2011-12-26 09:02:56.56 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2011-12-26 09:02:56.56 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per nod
e. This is an informational message only. No user action is required.
2011-12-26 09:02:56.64 Server Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a des
cription of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-12-26 09:02:56.65 Server Database Mirroring Transport is disabled in the endpoint configuration.
2011-12-26 09:02:56.67 spid7s Warning ******************
2011-12-26 09:02:56.67 spid7s SQL Server started in single-user mode. This an informational message only. No user action is required.
2011-12-26 09:02:56.68 spid7s Starting up database 'master'.
2011-12-26 09:02:56.68 spid7s Error: 17207, Severity: 16, State: 1.
2011-12-26 09:02:56.68 spid7s FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error 6(The handle is invalid.) occurre
d while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct the operating s
ystem error, and retry the operation.
2011-12-26 09:02:56.78 spid7s 5 transactions rolled forward in database 'master' (1). This is an informational message only. No user ac
tion is required.
2011-12-26 09:02:56.79 spid7s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user actio
n is required.
2011-12-26 09:02:56.79 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user
action is required.
2011-12-26 09:02:56.93 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'.
2011-12-26 09:02:56.98 spid7s SQL Trace ID 1 was started by login "sa".
2011-12-26 09:02:56.98 spid7s Starting up database 'mssqlsystemresource'.
2011-12-26 09:02:57.01 spid7s The resource database build version is 10.00.2531. This is an informational message only. No user action
is required.
2011-12-26 09:02:57.21 spid9s Starting up database 'model'.
2011-12-26 09:02:57.22 spid7s Server name is 'HOME-82A69B51CA\SQLEXPRESS'. This is an informational message only. No user action is req
uired.
2011-12-26 09:02:57.24 spid7s Informational: No full-text supported languages found.
2011-12-26 09:02:57.25 spid9s Error: 17207, Severity: 16, State: 1.
2011-12-26 09:02:57.25 spid9s FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error 6(The handle is invalid.) occurre
d while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf'. Diagnose and correct the operating sy
stem error, and retry the operation.
2011-12-26 09:02:57.38 spid9s Clearing tempdb database.
2011-12-26 09:02:57.58 spid9s Error: 17207, Severity: 16, State: 1.
2011-12-26 09:02:57.58 spid9s FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error 6(The handle is invalid.) occurre
d while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating s
ystem error, and retry the operation.
2011-12-26 09:02:57.60 Server A self-generated certificate was successfully loaded for encryption.
2011-12-26 09:02:57.61 Server Server is listening on [ 'any' <ipv4> 2144].
2011-12-26 09:02:57.61 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
2011-12-26 09:02:57.62 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
2011-12-26 09:02:57.62 Server Dedicated administrator connection support was not started because it is disabled on this edition of SQL
Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational mess
age only. No user action is required.
2011-12-26 09:02:57.63 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL
Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerbe
ros. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2011-12-26 09:02:57.63 Server SQL Server is now ready for client connections. This is an informational message; no user action is requi
red.
2011-12-26 09:02:57.77 spid9s Starting up database 'tempdb'.
2011-12-26 09:02:57.78 spid9s Error: 17207, Severity: 16, State: 1.
2011-12-26 09:02:57.78 spid9s FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error 6(The handle is invalid.) occurre
d while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating s
ystem error, and retry the operation.
2011-12-26 09:02:57.88 spid7s Recovery is complete. This is an informational message only. No user action is required.
2011-12-26 09:03:26.22 Logon Error: 18461, Severity: 14, State: 1.
2011-12-26 09:03:26.22 Logon Login failed for user 'HOME-82A69B51CA\Sailu'. Reason: Server is in single user mode. Only one administra
tor can connect at this time. [CLIENT: <local machine>]
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Sailu>sqlcmd -S.\sqlexpress -E
Msg 18461, Level 14, State 1, Server HOME-82A69B51CA\SQLEXPRESS, Line 1
Login failed for user 'HOME-82A69B51CA\Sailu'. Reason: Server is in single user
mode. Only one administrator can connect at this time.
C:\Documents and Settings\Sailu>
December 25, 2011 at 8:57 pm
Asked here also
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=169550
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
December 25, 2011 at 11:10 pm
How to troubleshoot Error 17204 and 17207 in SQL Server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply