Unable To Start SQL Express 2005 Service As A Network User
Oct 4, 2007
I am trying to start ms sql server 2005 express as a network user from originally starting as local system. I cannot start the service.
I have given this network user administrator access to sql express from the sql server surface area configuration "Add New Administrator". I have went into the local users/groups and added this network user to the 3 security groups
SQLServer2005MSSQLServerADHelperUser$SQL1
SQLServer2005MSSQLUser$SQL1$SQLEXPRESS
SQLServer2005MSSQLBrowserUser$SQL1
I receive one alert int he event logs/application
EventID: 26010
The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.
I receive five errors in the event logs/application
EventID: 26014
Unable to load user specified certificate. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.
EventID: 17182
TDSSNIClient initialization failed with error 0x80092004, status code 0x80
EventID: 17182
TDSSNIClient initialization failed with error 0x80092004, status code 0x1
EventID: 17826
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately prceding this one in the error log.
EventID: 17120
SQL Server could not spawn the FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
I don't recall assigning any sql specific certificates. The reason I'm trying to run this as a network user is because an application on a remote windows server requires it.
After starting the service back running as local system as it was before, I went into the
SQL Server Management Studio Express and edited the properties for this new network user I wish to run the service as. I gave him full access including checking all grants in securables.
I now see a bit of a difference in the event logs with these errors.
EventID: 17058
initerrlog: Could not open the log file 'c:Program FilesMicrosoft SQL ServerMSSQL1MSSQLLOGERRORLOG.' Operating system error =5(Access is denied).
I saw a notification when changing the sql server service's logon that the new network user has been granted the log on locally right.
The second and last new error is
EventID: 17053
UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
View 6 Replies
ADVERTISEMENT
Jul 4, 2007
hi all
i'm using a domain accout to setup a sql 2005 cluster in a win2003 cluster.when the installation ended,the SqlServerAgent service can't be started.the event in event viewer
is "SQLServerAgent could not be started (reason: Unable to connect to server "(local)"; LServerAgent
cannot start). " (event id 103 ,source sqlserveragent).I try to use local system and network service account to start it,but it's all the same.
And i found i can connect to the sql cluster vitrual ip 10.73.2.224,but can't connect to the node A.So i enable all the network protocols for the instance MSSQLSERVER,and also enable every ip in the TCP/IP protocol,then restart the sqlserver service,but it still doesn't work.
Any advise?Thanks a lot.
View 3 Replies
View Related
Aug 12, 2007
All,
I have installed sqlserver 2005 using the standard msdn universal installation discs on my laptop running vista business.
The mssqlserver service will not start automatically as the setup configures it
and I cannot start the service manually because I get the 'Access Denied' error message
I am logged on the the computer with adminstration privileges
Thank for all help received in advance,
Dave.....
View 2 Replies
View Related
Feb 2, 2008
I'm having a 3.0 GHz machine with 512MB Ram. however when i tried to run sql server 2005. this is the result of the System Configuration Check
- WMI Service Requirement (Success)
Messages
* WMI Service Requirement
* Check Passed
- MSXML Requirement (Success)
Messages
* MSXML Requirement
* Check Passed
- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed
- SQL Server Edition Operating System Compatibility (Warning)
Messages
* SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
- Minimum Hardware Requirement (Warning)
Messages
* Minimum Hardware Requirement
* The current system does not meet the minimum hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.
- IIS Feature Requirement (Warning)
Messages
* IIS Feature Requirement
* Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed
- Performance Monitor Counter Requirement (Success)
Messages
* Performance Monitor Counter Requirement
* Check Passed
- Default Installation Path Permission Requirement (Success)
Messages
* Default Installation Path Permission Requirement
* Check Passed
- Internet Explorer Requirement (Success)
Messages
* Internet Explorer Requirement
* Check Passed
- COM Plus Catalog Requirement (Success)
Messages
* COM Plus Catalog Requirement
* Check Passed
- ASP.Net Version Registration Requirement (Success)
Messages
* ASP.Net Version Registration Requirement
* Check Passed
- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed
furthermore i get error 26 when trying to create new sql server database. and while doing the SQL server surface area configuration i got this message.:
SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)
------------------------------
Program Location:
at Microsoft.SqlSac.MainPanel.FormFeatures..ctor(String machineName, Form callingForm)
HOpefully somebody out there will help me...or is this problem only appearing in sql server 2005 and would it be a better decision to install SQL server 2000...or if someone can help me rectify this problem i'll be really thankful.
View 4 Replies
View Related
Mar 24, 2008
Hi
I've tried downloading SQL Express 2005 but it will not install properly, stating that it is already installed. I cannot get the SQLExpress Service to start. I keep getting the message (The request failed or the service did not respond in a timely fashion). Can anyone help or point me in the right direction?
Thanks
View 6 Replies
View Related
Apr 1, 2008
System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
i get the above error when attepting to install reporting services
View 1 Replies
View Related
Mar 26, 2006
2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation.
2006-03-26 20:33:09.42 Server All rights reserved.
2006-03-26 20:33:09.42 Server Server process ID is 2068.
2006-03-26 20:33:09.42 Server Logging SQL Server messages in file 'd:SQL Server 2005MSSQL.1MSSQLLOGERRORLOG'.
2006-03-26 20:33:09.42 Server This instance of SQL Server last reported using a process ID of 1624 at 3/26/2006 8:32:45 PM (local) 3/26/2006 12:32:45 PM (UTC). This is an informational message only; no user action is required.
2006-03-26 20:33:09.42 Server Registry startup parameters:
2006-03-26 20:33:09.42 Server -d d:SQL Server 2005MSSQL.1MSSQLDATAmaster.mdf
2006-03-26 20:33:09.43 Server -e d:SQL Server 2005MSSQL.1MSSQLLOGERRORLOG
2006-03-26 20:33:09.43 Server -l d:SQL Server 2005MSSQL.1MSSQLDATAmastlog.ldf
2006-03-26 20:33:09.43 Server Command Line Startup Parameters:
2006-03-26 20:33:09.43 Server -m SqlSetup
2006-03-26 20:33:09.43 Server SqlSetup
2006-03-26 20:33:09.43 Server -Q
2006-03-26 20:33:09.43 Server -q SQL_Latin1_General_CP1_CI_AS
2006-03-26 20:33:09.43 Server -T 4022
2006-03-26 20:33:09.43 Server -T 3659
2006-03-26 20:33:09.43 Server -T 3610
2006-03-26 20:33:09.43 Server -T 4010
2006-03-26 20:33:09.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-03-26 20:33:09.43 Server Detected 1 CPUs. This is an informational message; no user action is required.
2006-03-26 20:33:09.51 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-03-26 20:33:09.53 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-03-26 20:33:09.53 spid5s Warning ******************
2006-03-26 20:33:09.53 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
2006-03-26 20:33:09.53 spid5s Starting up database 'master'.
2006-03-26 20:33:09.60 spid5s SQL Trace ID 1 was started by login "sa".
2006-03-26 20:33:09.64 spid5s Starting up database 'mssqlsystemresource'.
2006-03-26 20:33:09.78 spid7s Starting up database 'model'.
2006-03-26 20:33:09.84 spid5s Server name is 'XYZ-FNB5RZRU9ZP'. This is an informational message only. No user action is required.
2006-03-26 20:33:09.84 spid5s Starting up database 'msdb'.
2006-03-26 20:33:09.98 Server A self-generated certificate was successfully loaded for encryption.
2006-03-26 20:33:09.99 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ].
2006-03-26 20:33:09.99 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2006-03-26 20:33:09.99 Server Error: 17826, Severity: 18, State: 3.
2006-03-26 20:33:09.99 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2006-03-26 20:33:09.99 Server Error: 17120, Severity: 16, State: 1.
2006-03-26 20:33:09.99 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
View 6 Replies
View Related
May 1, 2008
I am unable to start SQL service on my system after i rebooted it
following is the message that i get
SQL Service on Local Computer started and then stopped. Some service stop automatically if they have no work to do
following is the corresponding entry in event viewer
TDSSNIClient initialization failed with error 0x7e, status code 0x60.
View 8 Replies
View Related
Jan 12, 2004
Message logged in the SQL Server is
Failed to report the current event. Operating
system error = 31(A device attached to the system is not functioning.).
The OS has been Shutdown and Restarted again but I am not able to start the SQL Server thereafter.
Kindly Suggest
View 8 Replies
View Related
Apr 28, 2004
Hi Gurus,
I have installed MS analysis service(OLAP) on my lap top
my user is in the Administrative group , other than that I tried creating a user with 'OLAP ADMINISTRATOR' privilate and tried to start the ms analysis service
I am getting the error , unable to start the service on server(), you are not a member of OLAP Administrators group
I tried to install the service pack 3 from Microsoft
Could you pleae guide me to start this serivice
Thanks,
View 2 Replies
View Related
Sep 7, 2006
Hi all
When i started the service, i am getting the following message
Starting up database 'master'.
Error: 9003, Severity: 20, State: 1.
Cannot recover the master database. Exiting.
i tried starting using -f -m paramters,but could not succeed
i don't have any backups for master database
is there any way i can restore it from .mdf, .ldf files..
Pls suggest..
Thanks in advance
View 12 Replies
View Related
Jan 23, 2008
Hi,
I was unable to start SQL Browser Services (time out) after installing SQL Server 2005 Analysis Services. The configuration of the server is
1. Win 2003 R2
2. Sql Server 2000 SP4
3. Sql Server 2005
Anybody has encountered this before? Any advice will be good.
Thanks!!
View 1 Replies
View Related
Apr 25, 2007
Hi,
When I click on SQL Server agent I get the "Unable to start service error".
It says serivce started and stopped.
Anybody having any clue on what's going wrong. Please let me know.
Regards,
HV
View 3 Replies
View Related
Jun 22, 2007
In the last step of installing the SQL Server 2005 Express edition I get the following error:
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007
Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007
Service failed unexpectedly (1814)
Error Code: 0x80070716 (1814)
Windows Error Text: The specified resource name cannot be found in the image file.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqlservicetart
Source Line Number: 301
---- Context -----------------------------------------------
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Error Code: 1814
MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1814) The specified resource name cannot be found in the image file.
.
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1814) The specified resource name cannot be found in the image file.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007
Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007
Service failed unexpectedly (1814)
Error Code: 0x80070716 (1814)
Windows Error Text: The specified resource name cannot be found in the image file.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqlservicetart
Source Line Number: 301
Any idea how I can fix this?
View 1 Replies
View Related
Sep 5, 2007
Hello,
I have Vista x64 and I had been fighting SQL Server for a few days and yesterday I decided for reinstallation. Unfortunately now I am not able to instal the server back!
Each time I got the following error (it refers to SQL Server service):
Code Snippet
<Func Name='LaunchFunction'>
Function=Do_sqlShutDownRANUInstance
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlShutDownRANUInstance
PerfTime Start: Do_sqlShutDownRANUInstance : Tue Sep 04 23:32:16 2007
<Func Name='Do_sqlShutDownRANUInstance'>
Service SQLEXPRESS with parameters '' is being started at Tue Sep 04 23:32:16 2007
Unable to start service (3)
Error Code: 0x80070003 (3)
Windows Error Text: System nie może odnaleźć określonej ścieżki.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls::Service::Start
Source Line Number: 316
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 3
MSI (s) (F4:E4) [23:32:24:490]: I/O on thread 3716 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:493]: I/O on thread 788 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:493]: I/O on thread 2948 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:493]: I/O on thread 4392 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:493]: I/O on thread 5048 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:495]: I/O on thread 4464 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:495]: I/O on thread 4992 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:495]: I/O on thread 4768 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:497]: I/O on thread 3004 could not be cancelled. Error: 1168
MSI (s) (F4!4C) [23:32:24:497]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) System nie może odnaleźć określonej ścieżki.
.
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) System nie może odnaleźć określonej ścieżki.
.
<Failure Type='Fatal' Error='3'>
<EndFunc Name='LaunchFunction' Return='3' GetLastError='203'>
MSI (s) (F4:80) [23:32:24:507]: User policy value 'DisableRollback' is 0
MSI (s) (F4:80) [23:32:24:507]: Machine policy value 'DisableRollback' is 0
Action ended 23:32:24: InstallFinalize. Return value 3.
MSI (s) (F4:80) [23:32:24:512]: Executing op: Header(Signature=1397708873,Version=400,Timestamp=925154312,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (F4:80) [23:32:24:512]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (F4:80) [23:32:24:513]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)
MSI (s) (F4:80) [23:32:24:514]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (F4:80) [23:32:24:516]: Executing op: ActionStart(Name=Do_sqlShutDownRANUInstance.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Running action to shutdown instance(Run As Normal User),)
MSI (s) (F4:80) [23:32:24:517]: Executing op: ProductInfo(ProductKey={C3F5DBA5-ABFC-443E-AA60-928223AADF53},ProductName=Microsoft SQL Server 2005,PackageName=sqlrun_sql.msi,Language=1033,Version=151129058,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=Setup,PackageCode={08AD0897-0300-4F7D-A3CC-A0CCEDD42E0D},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0,ProductDeploymentFlags=3)
MSI (s) (F4:80) [23:32:24:518]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (F4:80) [23:32:24:519]: Executing op: RegOpenKey(Root=-2147483646,Key=SOFTWAREMicrosoftWindowsCurrentVersionSharedDLLs,,BinaryType=0,)
MSI (s) (F4:80) [23:32:24:520]: Executing op: RegOpenKey(Root=-2147483646,Key=SOFTWAREMicrosoftWindowsCurrentVersionSharedDLLs,,BinaryType=0,)
MSI (s) (F4:80) [23:32:24:520]: Executing op: ComponentUnregister(ComponentId={68C6D258-77E0-11D5-8528-00C04F68155C},ProductKey={C3F5DBA5-ABFC-443E-AA60-928223AADF53},BinaryType=0,)
MSI (s) (F4:80) [23:32:24:520]: Executing op: ComponentUnregister(ComponentId={68C6D257-77E0-11D5-8528-00C04F68155C},ProductKey={C3F5DBA5-ABFC-443E-AA60-928223AADF53},BinaryType=0,)
What can I do solve the problem?
View 1 Replies
View Related
Jun 10, 2007
I am trying to migrate a instance , while trying to rename the server i am getting the following error.
Error: Instance name exceeds maximum length
Aborting Initialization
The instance name is 20 char long.
Please let me know if there is any workaround.
Thanks in advance.
View 3 Replies
View Related
Jul 22, 2007
Hello Friends
I'm running VS2005prof.+sp1, SSE Adv (with sp2) SSE ToolKit. Its been running without problems since installation (April 12.2007) Last week I ran into a problem which started off as
"An attempt to attach an auto-named database for file D:DataVBNetVisual Studio 2005ProjectSolutionsAR1403inDebuginDebugApp_DataAR1403.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
and went down hill rapidly to the point now where I can't even start it up. Here's the error log:
2007-07-21 22:51:07.55 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-07-21 22:51:07.55 Server (c) 2005 Microsoft Corporation.
2007-07-21 22:51:07.55 Server All rights reserved.
2007-07-21 22:51:07.55 Server Server process ID is 2656.
2007-07-21 22:51:07.55 Server Authentication mode is WINDOWS-ONLY.
2007-07-21 22:51:07.56 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-07-21 22:51:07.56 Server This instance of SQL Server last reported using a process ID of 304 at 7/21/2007 5:42:20 PM (local) 7/21/2007 9:42:20 PM (UTC). This is an informational message only; no user action is required.
2007-07-21 22:51:07.66 Server Registry startup parameters:
2007-07-21 22:51:07.66 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-07-21 22:51:07.66 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-07-21 22:51:07.66 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-07-21 22:51:07.75 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-07-21 22:51:07.75 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-07-21 22:51:07.86 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-07-21 22:51:08.02 Server Database mirroring has been enabled on this instance of SQL Server.
2007-07-21 22:51:08.04 spid5s Starting up database 'master'.
2007-07-21 22:51:08.70 spid5s SQL Trace ID 1 was started by login "sa".
2007-07-21 22:51:08.85 spid5s Starting up database 'mssqlsystemresource'.
2007-07-21 22:51:08.99 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-07-21 22:51:09.51 spid8s Starting up database 'model'.
2007-07-21 22:51:09.51 spid5s Server name is 'ADSSQLEXPRESS'. This is an informational message only. No user action is required.
2007-07-21 22:51:09.52 spid5s Starting up database 'msdb'.
2007-07-21 22:51:10.08 Server Error: 17190, Severity: 16, State: 1.
2007-07-21 22:51:10.08 Server FallBack certificate initialization failed with error code: 1.
2007-07-21 22:51:10.08 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2007-07-21 22:51:10.08 Server Error: 17182, Severity: 16, State: 1.
2007-07-21 22:51:10.08 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
2007-07-21 22:51:10.08 Server Error: 17182, Severity: 16, State: 1.
2007-07-21 22:51:10.08 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x1.
2007-07-21 22:51:10.08 Server Error: 17826, Severity: 18, State: 3.
2007-07-21 22:51:10.08 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-07-21 22:51:10.08 Server Error: 17120, Severity: 16, State: 1.
2007-07-21 22:51:10.08 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
-----------
I've tried following various suggestions I found on the Net, however, after 3-days it does seem as though I'm not getting anywhere. Shoud I uninstall and re-install SSE and if so is there a specific step by step step procedure I can follow. Or is there a sure fire way to fix the probelm without re-installation?
Your help is greatly appreciated.
Gary
View 4 Replies
View Related
Apr 23, 2007
Sorry if this is a simple question, I've not seen any similar posts.
I'm just finished installed SQL 2005 on Vista Business edition (first time for both). I subsequently installed SP2 for 2005.
Upon completing the SP2 installation, the SQL Server Surface Area Configuration manager opened asking me to grant admin rights to the account I used to install the software. The account I used is the local admin account on the machine (only account on the machine as this is my dev box) .
Nothing shows in the two boxes below on this dialog, "Available Privelages" is blank and "Privelages granted is blank".
In addition, if I go to SQL Server Configuration Manager, and click on SQL Server 2005 Services, nothing shows in the right pain. It's as if the software installed, and yet no instance of the database exists or is running.
My thought was that the admin account I used to install the software doesn't have sufficient privelages to to start the SQL Server or SQLBrowser. So I went to computer management, Local Users and groups (machine isn't on a network yet), and made sure this same account is part of the administrators group.
Any ideas on how I should solve this?
View 1 Replies
View Related
Aug 20, 2015
SQL script that creates a User Mapping for NT AUTHORITYNETWORK SERVICE to a database?
View 3 Replies
View Related
Apr 28, 2006
Hello All,
I am installing SQL Server Express from the command line using the following parameters
INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD=TEST
After the install is done I start the service form the command prompt using
start mssqlserver
I see that the SQL Server service has started under NETWORK SERVICE account!!! when the documentation i Read on MSDN says it starts in Local System account
Can any one explain me the possible reasons
Thanks
View 8 Replies
View Related
Mar 11, 2008
I'm using the methods of the Microsoft.SqlServer.Management.Smo namespace within a .NET application to create a backup file from a SQLEXPRESS database. I can then restore the database from that backup device using methods in the same namespace. Here is a snippet from the restore code:
srv = New Server("MYPCSQLEXPRESS")
db = srv.Databases("washmaster")
Dim bdi As New BackupDeviceItem(BackupFileName, DeviceType.File)
Dim recoverymod As RecoveryModel
recoverymod = db.DatabaseOptions.RecoveryModel
rs.NoRecovery = False
rs.Devices.Add(bdi)
rs.Database = "washmaster"
rs.ReplaceDatabase = True
srv.KillAllProcesses("washmaster")
rs.SqlRestore(srv)
This works great as long as I used one of the backup files that I created directly on the disk. However, my application has a utility that allows the user to copy the backup files onto another drive, such as a CD or a thumb drive and when I try to restore from the copy of the backup, I get the following exception:
....Cannot open backup device..[filename]...Operating system error 5(Access is denied.)
The reason I get this error is that the "NETWORK SERVICE" account was removed from the file permissions when the file was copied.
How can I copy a backup to another drive and preserve the "NETWORK SERVICE" account? If I can't do that, is it wise to try to add the account back to the file before using it to restore or is there a better way?
Thanks,
SJonesy
View 3 Replies
View Related
Feb 18, 2008
set up asp .net user account on sql server 2005Question:
I've read the instructions in this article: http://www.netomatix.com/Development/aspnetuserpermissions.aspxBut do not know how to do this:You can grant 'Network Service' or 'ASPNET' user accounts permissions to connect to database.Please provide example on how to do this, thanks!
View 2 Replies
View Related
Apr 17, 2006
I have had SQL Server 2005 (Full Version) installed along with SQL Server Express and suddenly SQL Express quit starting and will not start manually. I have reinstalled VS 2005 (Team Edition for Software Dev) and tried to reinstall SQL Express but the installation fails when it tries to start the service. Any suggestions?
Keith
View 9 Replies
View Related
May 13, 2008
Hello all,
We are deploying an application using SQL Server Express to a wide variety of desktop and laptop machines. We are currently trying to decide whether we should install the SQL Server instance service to start automatically at startup or not. In the latter case, our application would start and stop the service.
Starting automatically will make our app load more quickly, which is important to our users. However, our support team is concerned that leaving the service running will leave our databases vulnerable to becoming "suspect" if, for example, a laptop user's battery dies suddenly. Of course this will always be a problem if the app is running, but our support team believes that having the service running all the time will increase the chances of this happening. One reason for their concern is that an older version of the software used MSDE which was running all the time, and they saw a good number of suspect database issues.
What is the best practice for leaving the service running, especially when there are a lot of laptop users?
Thanks,
Ben
View 3 Replies
View Related
Aug 22, 2007
Hi all,
I have SQL Server Express and VB 2005 Express installed in a Microsoft Windows XP Pro PC that is a terminal PC in our office Network. My Network Administrator has granted my terminal PC for Administrator Use. I tried to do the ADO.NET 2.0-VB 2005 programming in my terminal PC and I could not get a remote connection in the Window Form Application via Window Authorization. I do not know how to make this kind of remote connection in my Network. Please help and advise.
Thanks in advance,
Scott Chang
View 6 Replies
View Related
Feb 22, 2007
Ran the SP2 locally on a Windows Server 2003 SP1 box that had SQL Server 2005 SP1 install on it. Problem was I ran out of C: drive and it failed in the middle of upgrading the server.
I'm unable to start the SQL Server at all now. Is there any way to back this out? Don't think I can reapply any patches since the service is dead.
Eventlog now shows:
One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
The log shows it's unable to start SQL (blames it on permisions but it's because SQL can no longer start)
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29538
Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmssqlsystemresource1.mdf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
I'm guessing its reinstall time but not sure how the attached databases will like that idea.
Thanks in advance for any ideas.
View 6 Replies
View Related
Sep 19, 2007
Hi all,
In my office computer network system (LAN), my Windows XP Pro PC has SQL Server Express and VB 2005 Express installed and I was granted to have the Administrator priviledge to access SQL Server Express. I tried to create a SQLCLR project in my terminal PC.
1) I tried to set up a remote connection to SQL Server Express in the following way: SQL Server EXpress => SQL Server Surface Area Configuration. In the Surface Area Configuration for Service and Connection - local, I clicked on Remote Connection of Database Engine, SQLEXPRESS and I had a "dot" on "Local and remote connections" and "Using TCP/IP only". Then I clicked on "Apply" and "OK" buttons. Then I went to restart my database engine in SQL Server Management. When I went to check SQL Server 2005 Surface Area Configuration, I saw the arrow is pointing to "Service", not to "Remote Connections"!!!??? Is it right/normal? Please comment on this matter and tell me how I can have "Remote Connecton" on after I selected it.
2) After I restarted the database engine (I guess!!), I executed the following project code (copied from a book) in my VB 2005 Express:
//////////////--Form9.vb---/////////////////
mports System.Data.SqlClient
Imports System.Data
Public Class Form9
Dim cnn1 As New SqlConnection
Private Sub Form5_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Compute top-level project folder and use it as a prefix for
'the primary data file
Dim int1 As Integer = InStr(My.Application.Info.DirectoryPath, "bin")
Dim strPath As String = Microsoft.VisualBasic.Left(My.Application.Info.DirectoryPath, int1 - 1)
Dim pdbfph As String = strPath & "northwnd.mdf"
Dim cst As String = "Data Source=.sqlexpress;" & _
"Integrated Security=SSPI;" & _
"AttachDBFileName=" & pdbfph
cnn1.ConnectionString = cst
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Create a command to create a table
Dim cmd1 As New SqlCommand
cmd1.CommandText = "CREATE TABLE FromExcel (" & _
"FirstName nvarchar(15), " & _
"LastName nvarchar(20), " & _
"PersonID int Not Null)"
cmd1.Connection = cnn1
'Invoke the command
Try
cnn1.Open()
cmd1.ExecuteNonQuery()
MessageBox.Show("Command succeeded.", "Outcome", _
MessageBoxButtons.OK, MessageBoxIcon.Information)
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cnn1.Close()
End Try
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Create a command to drop a table
Dim cmd1 As New SqlCommand
cmd1.CommandText = "DROP TABLE FromExcel"
cmd1.Connection = cnn1
'Invoke the command
Try
cnn1.Open()
cmd1.ExecuteNonQuery()
MessageBox.Show("Command succeeded.", "Outcome", _
MessageBoxButtons.OK, MessageBoxIcon.Information)
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cnn1.Close()
End Try
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
'Declare FromExcel Data Table and RowForExcel DataRow
Dim FromExcel As New DataTable
Dim RowForExcel As DataRow
FromExcel.Columns.Add("FirstName", GetType(SqlTypes.SqlString))
FromExcel.Columns.Add("LastName", GetType(SqlTypes.SqlString))
FromExcel.Columns.Add("PersonID", GetType(SqlTypes.SqlInt32))
'Create TextFieldParser for CSV file from spreadsheet
Dim crd1 As Microsoft.VisualBasic.FileIO.TextFieldParser
Dim strPath As String = _
Microsoft.VisualBasic.Left( _
My.Application.Info.DirectoryPath, _
InStr(My.Application.Info.DirectoryPath, "bin") - 1)
crd1 = My.Computer.FileSystem.OpenTextFieldParser _
(My.Computer.FileSystem.CombinePath(strPath, "Book1.csv"))
crd1.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited
crd1.Delimiters = New String() {","}
'Loop through rows of CSV file and populate
'RowForExcel DataRow for adding to FromExcel
'Rows collection
Dim currentRow As String()
Do Until crd1.EndOfData
Try
currentRow = crd1.ReadFields()
Dim currentField As String
Dim int1 As Integer = 1
RowForExcel = FromExcel.NewRow
For Each currentField In currentRow
Select Case int1
Case 1
RowForExcel("FirstName") = currentField
Case 2
RowForExcel("LastName") = currentField
Case 3
RowForExcel("PersonID") = CInt(currentField)
End Select
int1 += 1
Next
int1 = 1
FromExcel.Rows.Add(RowForExcel)
RowForExcel = FromExcel.NewRow
Catch ex As Microsoft.VisualBasic.FileIO.MalformedLineException
MsgBox("Line " & ex.Message & _
"is not valid and will be skipped.")
End Try
Loop
'Invoke the WriteToServer method fo the sqc1 SqlBulkCopy
'object to populate FromExcel table in the database with
'the FromExcel DataTable in the project
Try
cnn1.Open()
Using sqc1 As SqlBulkCopy = New SqlBulkCopy(cnn1)
sqc1.DestinationTableName = "dbo.FromExcel"
sqc1.WriteToServer(FromExcel)
End Using
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cnn1.Close()
End Try
'Read the FromExcel table and display results in
'a message box
Dim strQuery As String = "SELECT * " & _
"FROM dbo.FromExcel "
Dim str1 As String = ""
Dim cmd1 As New SqlCommand(strQuery, cnn1)
cnn1.Open()
Dim rdr1 As SqlDataReader
rdr1 = cmd1.ExecuteReader()
Try
While rdr1.Read()
str1 += rdr1.GetString(0) & ", " & _
rdr1.GetString(1) & ", " & _
rdr1.GetSqlInt32(2).ToString & ControlChars.CrLf
End While
Finally
rdr1.Close()
cnn1.Close()
End Try
MessageBox.Show(str1, "FromExcel")
End Sub
End Class
//////////////////////////////////////////////////////////////////////////////
I got the following error messages:
SecurityException was unhandled
Request for the permission of type 'System. Security. Permissions.FileIOPermission,mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'failed that is pointing to the code statement "Dim int1 As Integer = InStr (My.Application.Info.DirectoryPath, "bin")."
Troubleshooting tips:
Store application data in isolated storage.
When deploying an Office solution, check to make sure you have fulfilled all necessary requirments.
Use a certificate to obtain the required permission(s).
If an assembly implementing the custom security references other assemblies, add the referenced assemblies to the full trust assembly list.
Get general help for the exception.
I am a new Microsoft VS.NET Express user to do the SQL Server 2005 Express and VB 2005 Express programming by using the example of a tutorial book. Please help and tell me what is wrong in my SQLCLR sep-up and project coding and how to correct the problems.
Many Thanks in advance,
Scott Chang
View 3 Replies
View Related
Nov 1, 2007
Hi! Im just starting to learn how to use an SQL express database. I used it over at my campus and it worked fine and now when I try running it on my machine it gave me this error :
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection.(Provider : SQL Network Interfaces, error : 26 - Error locating server/ instance specified.)"
I know that by default SQL express doesnt not support remote connection but when i try to get the service status running, i got another error which is :
"The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop this service. (SQLSAC)"
I am already logged on to the computer as an administrator but i still cant get the service to run! Pls help!
View 1 Replies
View Related
Jun 12, 2007
Hi can someone help me please? I browsed through the SP2 install feedback below, but it doesn't quite seem to fit what happened to my install. My .MDF and .LDF files for the system databases are in C:Program FilesMicrosoft SQL ServerMSQL.1MSQLData (I presume this is the correct location.)
I am the local administrator on this box.
I uploaded the .CAB file with all the logs onto www.sendspace.com if it gives you something to go on.
The only other thing of note is that it said there were two machines on the network and that I needed to change my machine name in the control panel when I installed. This doesn't seem right, as far as I understand the computer name is unique.
The SQL Server runs under the local system account, if that is of any use.
I attempted uninstalling and reinstalling the SQL native client MSI package in the hope it would be a simple fix similar to that chap further down the page, but that didn't help at all either.
.CAB file of installation logfiles is here: http://www.sendspace.com/file/7ihoet
kind regards
Jason
ERRORLOG starting SQL Server post failed SP2 install
2007-06-12 19:55:21.94 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-06-12 19:55:21.96 Server (c) 2005 Microsoft Corporation.
2007-06-12 19:55:21.96 Server All rights reserved.
2007-06-12 19:55:21.97 Server Server process ID is 5468.
2007-06-12 19:55:21.97 Server Authentication mode is MIXED.
2007-06-12 19:55:21.97 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-06-12 19:55:21.97 Server This instance of SQL Server last reported using a process ID of 5756 at 12/06/2007 19:36:35 (local) 12/06/2007 18:36:35 (UTC). This is an informational message only; no user action is required.
2007-06-12 19:55:21.97 Server Registry startup parameters:
2007-06-12 19:55:21.99 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-06-12 19:55:21.99 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-06-12 19:55:21.99 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-06-12 19:55:22.00 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-06-12 19:55:22.00 Server Detected 4 CPUs. This is an informational message; no user action is required.
2007-06-12 19:55:22.17 Server Address Windowing Extensions is enabled. This is an informational message only; no user action is required.
2007-06-12 19:55:22.33 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-06-12 19:55:22.57 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-06-12 19:55:23.60 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-06-12 19:55:23.63 Server Database mirroring has been enabled on this instance of SQL Server.
2007-06-12 19:55:23.72 spid5s Starting up database 'master'.
2007-06-12 19:55:24.07 spid5s SQL Trace ID 1 was started by login "sa".
2007-06-12 19:55:24.11 spid5s Starting up database 'mssqlsystemresource'.
2007-06-12 19:55:24.13 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-06-12 19:55:24.29 spid5s Server name is 'GBLOND088SQ8MSQL_CREDS_DEV1'. This is an informational message only. No user action is required.
2007-06-12 19:55:24.29 spid9s Starting up database 'model'.
2007-06-12 19:55:24.30 Server Error: 17182, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server TDSSNIClient initialization failed with error 0x34, status code 0x1e.
2007-06-12 19:55:24.30 Server Error: 17182, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server TDSSNIClient initialization failed with error 0x34, status code 0x1.
2007-06-12 19:55:24.30 Server Error: 17826, Severity: 18, State: 3.
2007-06-12 19:55:24.30 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-06-12 19:55:24.30 Server Error: 17120, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
View 7 Replies
View Related
Oct 15, 2007
A few service stop/start/restart questions on SQL Server 2005 SP2, whichI'll call SQLS.It looks as if there are *potentially* 6 ways to start/stop SQLSServices like the engine itself, integration services, reportingservice, Agent..-SQLS Configuration Manager-SQLS Surface Area Configuration (for Services and Connections)-Mgmt Studio Local (on server)-Mgmt Studio Remote (on client)-Windows Control Panel->Admin Tools->Services-Command Prompt (ala net start MSSQLSERVER)By policy, I am /not/ Administrator on the server. But I am SysAdminrole in SQLS. I have had various levels of success starting/stoppingservices in the ways listed above. In some I get Access denied, and inothers I get no msg and it simply doesn't work.Is there some special non-Admin OS group I need to be in to start/stopservices? Is this handled differently in the different interfaceslisted above?It seems like my best success for starting/stopping the engine and Agentis in /local/ Mgmt Studio, but /not/ remote Mgmt Studio - the optionsare greyed out on a remote client. Is this by design? Is it a SQLSbug?I'm sure I'm not the only SQLS DBA who does not have Admin rights on hisserver who wants to start/stop services. Generally speaking, how isthis intended to work?Any help appreciated.Allen JantzenA freshly minted DQLS DBA
View 1 Replies
View Related
Jul 16, 2007
Dear All,
I am not able to start the sql server 2005 database engine services...
Sql server 2005 server is installed in one machine(SERVER) and we have 10 client machine connecting to the server
When i try to start the service from the Service.msc in the SERVER i am getting the following error
===================================
Cannot connect to KEYSKILL.
===================================
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
------------------------------
Error Number: 2
Severity: 20
State: 0
------------------------------
Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Could any one help me to resolve the error
Thanks in Advance
Lalitha
View 6 Replies
View Related
Nov 26, 2007
Hello all,
I am intsalling SQL 2005 in an activepassive cluster. The OS is Windows 2003 with SP1. Everything installs OK but the sql server service cannot start afterwards. There are many access errors in the Security Event log - see example below - and numerous "SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. " errors in both the SQL and Application event logs. I have tried installing SQL in both mixed mode and under Windows Authentication and get the same errors. I can install SQL 2005 outside of the cluster on both nodes. Other items of note: This was a SQL 2000 cluster. I uninstalled SQL 2K, the virtual name was changed (IP remained the same) and the DNS entry was updated to reflect the new name. Early in the installation process - 3 or 4 days ago - I got a few errors about the Server Principal Name had to be updated but when I do a setspn -l the both nodes are listed and the entries look fine, though there are no entries for the sql service (MSSQLSvc). Not sure if there should be entries for the virtual name, but there aren't any for either the old or new name. Does the new virtual name need to be added to AD? Here is the security error - Event ID is 560 and it looks like there's a problem with Remote Access and is generated when trying to access either node:
Category: Object Access
Type: Failure Audit
Event_ID: 560
User: NT AuthorityNetwork Service
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: RemoteAccess
Handle ID: -
Operation ID: {0,134558507}
Process ID: 1516
Image File Name: C:WINDOWSsystem32services.exe
Primary User Name: CM-OHCO-DS006B$
Primary Domain: SWNA
Primary Logon ID: (0x0,0x3E7)
Client User Name: NETWORK SERVICE
Client Domain: NT AUTHORITY
Client Logon ID: (0x0,0x3E4)
Accesses: Query status of service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x4
One other informational message that may be of use - looks like there's a problem with dll's for remote access, though this isn't pertaining to SQL:
The description for Event ID ( 0 ) in Source ( srmservice ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: srmservice error: 0, Started the agent (srmagent.exe)..
View 5 Replies
View Related