May 10, 2009 at 8:44 am
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
May 13, 2009 at 10:37 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply