January 11, 2017 at 12:44 pm
Hi All,
Not sure, why am I having so many issues with LocalInstance. I finally opened the ssms.exe and everything seems to be working fine. I tried to create a new database so I right clicked on my local instance and it started giving me the below error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null).
Could not load the DLL xpstar.dll, or one of the DLLs it references. Reason: (null). (Microsoft SQL Server, Error: 17750)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2318&EvtSrc=MSSQLServer&EvtID=17750&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I can create a database if I am in local instance 9.0.
I cannot create a database if I am in local instance 11.0. My Instance just says (loaclDB)\MyDevInstance (SQL server 11.0.2318-my name here).
Only difference I see is that 9.0 has a green start button, but 11.0 instance doe not have green start button in fron tof it. How can I start the local instance for 11.0
any help will be greatly appreciated. I can put the screen shot inthe post, but I am not sure how to do it. I have the image on my local machine.
January 11, 2017 at 2:58 pm
First, be sure that each instances services are up and running. There are a couple of ways to do that:
1.) Bring up Task Manager and validate that each SQL Server service that needs to run is running, including the SQL Browser service, as you have multiple instances on the same machine.
2.) Use the SQL Server Configuration Manager for each SQL Server version you have installed and start the appropriate services there.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply