Click here to Skip to main content
14,978,609 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Dear Friends,

I have installed MSSql 2012. While installation it didn't ask servername or any other credentials. After installing the software I'm unable to use it as it requires servername.. can any body help me.

Cheers
Posted

1 solution

Normally it is same as your computer name which you can get by right clicking on My Computer and click on Properties.
If that dosen't work, follow these steps
1. Select Browse for more... from the Server Name dropdown
2. Under Local Servers tab, expand Database Engine
3. Select the SQL Server instance. Ex: YourCompName\SQLServer2012

Hope, it helps :)
   
v2
Comments
amaansworld 31-Jul-15 1:27am
   
Thanks for reply.. I already tried computer name but it didn't work..

. Under Local Servers tab, expand Database Engine
>> There is no Database Engine showing there. it is blank.. Please advice..
Suvendu Shekhar Giri 31-Jul-15 1:35am
   
and then have you looked for that in the "Network Servers" tab?
Sometimes it is not displayed unders "Local Servers" (I don't know why, though)
amaansworld 31-Jul-15 12:58pm
   
I'm sorry I don't get your point.. Where I can find "Network Server" tab.


Suvendu Shekhar Giri 31-Jul-15 1:42am
   
One more way-
Go to services and look for SQL Server (Instance Name)
amaansworld 31-Jul-15 12:59pm
   
If you are talking about 'SQL Server Services" in "SQL Server Configuration Manager" then there it no value. It is blank..
Suvendu Shekhar Giri 31-Jul-15 15:23pm
   
No I was talking about system services which can be accessed by opening Run and write Services and press enter.
amaansworld 31-Jul-15 22:09pm
   
Dear Friend,

I tried it but it does nothing. No screen opens..
amaansworld 1-Aug-15 3:58am
   
I was just wondering if you can help me..

Please let me know..
Suvendu Shekhar Giri 1-Aug-15 12:38pm
   
If it is not listed in services(services.msc) then probably it's installation issue.
amaansworld 2-Aug-15 19:08pm
   
Sorry in the earlier msg you asked me to type "Services" but in the last msg you told "Services,msc". I write it and it opened a services box for me.. Could you please tell what should I check there?
Suvendu Shekhar Giri 3-Aug-15 0:19am
   
Look for SQL Server (Instance Name)
amaansworld 3-Aug-15 0:58am
   
It is showing SqlServer VSS Writer. No other name which start from Sql..
Suvendu Shekhar Giri 3-Aug-15 1:21am
   
Then I believe it is problem with the Installation. Suggestion to reinstall it (if there is no other concerns).
amaansworld 3-Aug-15 2:46am
   
Thank you.. Can you please give me URL from where I can download management studio 2012..earlier I downloaded it using msdn but it didn't ask me credentials.. can you please give me URL..
amaansworld 3-Aug-15 8:51am
   
Hello, Are you still available?
Suvendu Shekhar Giri 3-Aug-15 9:00am
   
Yes :)
This is the problem related to SQL Server (filename should be similar to "SQLEXPR_x64_ENU.exe") and not the management studio.
I can't gurantee but files downloaded from this link should work
https://www.microsoft.com/en-in/download/details.aspx?id=29062[^]
amaansworld 3-Aug-15 20:02pm
   
Okay how if I re install management studio?
Suvendu Shekhar Giri 4-Aug-15 0:29am
   
Actually, your problem seems to be with the SQL Server instance and Management studio is just a graphical management tool for managing/querying SQL Server. So I believe, re-installing only SQL Server Management Studio will not help. You can re-install the complete package also, if you want.
amaansworld 5-Aug-15 6:10am
   
Okay let me reinstall it.. Can you please give me URL to install complete package?
amaansworld 14-Aug-15 6:24am
   
Hello Sir,

I was able to use same software. I need your help.. Can you pls check 1 .bak file and let me know if it is blank or not.. I have uploaded the file on new server and they are telling .bak file is blank.. I really appreciate if you can check it on your system and let me know.. For this kindly share your email ID to upload file.

amaansworld 15-Aug-15 0:17am
   
can u pls help me?
Suvendu Shekhar Giri 17-Aug-15 0:41am
   
Was out of town for 3 days.
My email id is suvendu.giri@live.com
amaansworld 17-Aug-15 1:54am
   
Thank you very much.. Let me upload .bak files..
amaansworld 17-Aug-15 2:00am
   
Done.. Kindly check..
amaansworld 18-Aug-15 8:18am
   
Just wondering if you got my email.. Can you please help me..
amaansworld 18-Aug-15 8:45am
   
Just wondering if you got my email.. can you please help me?
Suvendu Shekhar Giri 19-Aug-15 4:19am
   
I am able to restore it successfully.
It has tables like-
tblAdminUser
tblCategory
tblCategoryProduct
etc.
amaansworld 19-Aug-15 6:09am
   
thank you.. I sent you two .bak files. can you please tell in which .bak files you see those record.. I really appreciate if you can check both .bak files and send me print screens.. I want to show it to hosting server coz they are not running my website and told me dbs are empty.. HOpe you understand and will help me..
Suvendu Shekhar Giri 19-Aug-15 6:24am
   
I am able to restore both the files and view tables.
Please check the mail for screenshots.
amaansworld 19-Aug-15 8:51am
   
Thanks for your help..
Suvendu Shekhar Giri 20-Aug-15 1:21am
   
:)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900