Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to access SQL Server Configuration Manager. Expand / Collapse
Author
Message
Posted Sunday, May 10, 2009 8:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 15, 2009 11:34 AM
Points: 7, Visits: 22
Hi,

After formating my system to Windows XP, installed Microsoft Sql Server 2005. When tried to access Sql server configuration manager, Following error pops up:

Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
Access is denied.

Uninstalled Sql server 2005 and reinstalled again but same error pops up.

Regards,
Pawani.






RE: Lost model.bak from system database

Author Message

pawani
Posted 2 days ago @ 6:53:02 PM , In: Administering

Forum Newbie



Group: General Forum Members
Last Login: Today @ 3:37:35 PM
Points: 6, Visits: 21
Hi GilaMonster,

Thanks, Now I am able to access model after logging in with sysadmin.
Preview #713228






RE: Lost model.bak from system database

Author Message

pawani
Posted 2 days ago @ 6:51:13 PM , In: Administering

Forum Newbie



Group: General Forum Members
Last Login: Today @ 3:37:35 PM
Points: 6, Visits: 21
Hi Robert,

Thanks, Now I logged in with sysadmin and I am able to access model.



Preview #713226






RE: Lost model.bak from system database

Author Message

pawani
Posted 5/6/2009 6:04:50 PM , In: Administering

Forum Newbie



Group: General Forum Members
Last Login: Today @ 3:37:35 PM
Points: 6, Visits: 21
Hi,
I received following Error log:

(c) 2005 Microsoft Corporation.
2009-05-06 22:08:19.66 Server All rights reserved.
2009-05-06 22:08:19.66 Server Server process ID is 2132.
2009-05-06 22:08:19.66 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-05-06 22:08:19.66 Server This instance of SQL Server last reported using a process ID of 2064 at 5/5/2009 11:58:45 PM (local) 5/5/2009 6:28:45 PM (UTC). This is an informational message only; no user action is required.
2009-05-06 22:08:19.66 Server Registry startup parameters:
2009-05-06 22:08:19.69 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-05-06 22:08:19.69 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-05-06 22:08:19.69 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-05-06 22:08:19.82 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-05-06 22:08:19.82 Server Detected 2 CPUs. This is an informational message; no user action is required.
2009-05-06 22:08:24.42 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.
2009-05-06 22:08:25.57 Server Database Mirroring Transport is disabled in the endpoint configuration.
2009-05-06 22:08:25.86 spid5s Starting up database 'master'.
2009-05-06 22:08:26.20 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2009-05-06 22:08:26.70 spid5s SQL Trace ID 1 was started by login "sa".
2009-05-06 22:08:26.78 spid5s Starting up database 'mssqlsystemresource'.
2009-05-06 22:08:27.48 spid8s Starting up database 'model'.
2009-05-06 22:08:27.54 spid5s Server name is 'SANJ-PC\SQLEXPRESS'. This is an informational message only. No user action is required.
2009-05-06 22:08:27.56 spid5s Starting up database 'msdb'.
2009-05-06 22:08:27.91 spid8s Clearing tempdb database.
2009-05-06 22:08:27.98 Server A self-generated certificate was successfully loaded for encryption.
2009-05-06 22:08:28.05 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
2009-05-06 22:08:28.05 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
2009-05-06 22:08:28.05 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.
2009-05-06 22:08:28.07 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2009-05-06 22:08:28.97 spid8s Starting up database 'tempdb'.
2009-05-06 22:08:29.10 spid5s Recovery is complete. This is an informational message only. No user action is required.
2009-05-06 22:08:29.18 spid11s The Service Broker protocol transport is disabled or not configured.
2009-05-06 22:08:29.25 spid11s The Database Mirroring protocol transport is disabled or not configured.
2009-05-06 22:08:29.54 spid11s Service Broker manager has started.

How to proceed further.
Preview #711313






RE: Lost model.bak from system database

Author Message

pawani
Posted 5/5/2009 6:15:54 PM , In: Administering

Forum Newbie



Group: General Forum Members
Last Login: Today @ 3:37:35 PM
Points: 6, Visits: 21
Hi,

I moved from Start-> Programs -> Microsoft Sql server 2005-> Sql server Management Studio Express->with server name:SANJ-PC\SQLEXPRESS, Aunthentication:Windows Authentication, user name:sanj-PC\sanj, then click connect,

Right click on database, Attach, then click Add, I get this pop up message.

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The server principal "sanj-PC\sanj" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
------------------------------
When tried to expand Databases, got system Databases, then expanded it, got master, model, msdb, tempdb.
I am able to expand master, msdb, tempdb, but when tried to expand model got this pop up error message:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
The database model is not accessible. (Microsoft.SqlServer.Express.ObjectExplorer)

------------------------------

Please let me know how do I proceed now.
Preview #710491






Lost model.bak from system database

Author Message Topic Views: 166, Topic Replies: 11

pawani
Posted 5/5/2009 10:20:30 AM , In: Administering

Forum Newbie



Group: General Forum Members
Last Login: Today @ 3:37:35 PM
Points: 6, Visits: 21
Lost model.bak from System databases,
Now unable to add new database, throws error server unable to connect to model.bak.

Traced the path: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup, here Backup folder is empty, It should have model.bak file, which is missing.

From where do I download model.bak, can anyone help me on this?
Preview #709997







Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use
Post #713718
Posted Wednesday, May 13, 2009 10:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:20 PM
Points: 32,764, Visits: 14,928
What is the question? Is it Configuration Manager or model? You've put a lot of information in the post which doesn't make sense.

It sounds like you don't have the proper permissions on your machine, or perhaps either XP has a corruption issue in the settings or your SQL installation has one.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #716188
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse