asked on
SQLexpress2014 - could not restore database
Hi guys,
I installed new sqlexpress 2015 in my server. While installing it asked to create instance which I did and all installed successfully.
When I open, sql server configuration manager - it shows “SQL Server(mssqlserver)” running.
I believe mssqlserver which in brackets is my instance name ??? Am I correct
And am trying to restore a database, into this new instance. Which fails- it says network related or instance specific error
And I don’t have sqlmanagemnet studio. It did not install with sqlexpress.
Do I need sqlmanagement studio to be installed ??? Am I seeing my instance name correctly ??
Any help would be great
I installed new sqlexpress 2015 in my server. While installing it asked to create instance which I did and all installed successfully.
When I open, sql server configuration manager - it shows “SQL Server(mssqlserver)” running.
I believe mssqlserver which in brackets is my instance name ??? Am I correct
And am trying to restore a database, into this new instance. Which fails- it says network related or instance specific error
And I don’t have sqlmanagemnet studio. It did not install with sqlexpress.
Do I need sqlmanagement studio to be installed ??? Am I seeing my instance name correctly ??
Any help would be great
Windows Server 2012Windows Server 2008Windows Server 2003
Last Comment
Mr.X
ASKER
hi, i found this command in google to find the instance name. but its giving me the same kind of error when i try to restore my database.
please have a look at the attached pic
instance.PNG
please have a look at the attached pic
instance.PNG
Yup. Cause I said: use (local)\SQLExpress to connect to. Thus use it instead of your servername\instancename.
ASKER
i tried it same issue. am just uninstalling sqlexpress.
i will install sql2014managemnet studio and will see how it goes. when i install management studio, do i need sqlexpress aswell ? ? or its 2 separate products which can work independentally
i will install sql2014managemnet studio and will see how it goes. when i install management studio, do i need sqlexpress aswell ? ? or its 2 separate products which can work independentally
*cough*
SSMS is only the management program. No database service. When you uninstall SQL Server Express, then you don't have any database instance to connect to.
SSMS is only the management program. No database service. When you uninstall SQL Server Express, then you don't have any database instance to connect to.
ASKER
oops. ok . i will install both in next 10 mins. i will give it a try and let you know how it goes .
ASKER
hi, i uninstalled and just installed expresssql alone, and it worked great :)
one more last question. how do i enable sql engine and sql browser ? ? anything needs to be done on firewall.router ?
if i want to use my applciation as web app, think i need to enable sqlengine and sqlbrowser.
one more last question. how do i enable sql engine and sql browser ? ? anything needs to be done on firewall.router ?
if i want to use my applciation as web app, think i need to enable sqlengine and sqlbrowser.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
An express instance is normally a named instance. Thus you should use (local)\SQLExpress in your connection string. Thus
sounds a little bit suspect.