Solved

sql server 2008

Posted on 2008-10-24
3
212 Views
Last Modified: 2010-03-20
I have asp.net installed and sql server 2008  installed .
I installed the sql SMSE which it says it is for 2005 sql server so is the a problem for 2008 sql server?

How do i create a database from sql SMSE because i have not set up a login to create a database .I need to My problem is I cant login into the sql SMSE to do anything.

0
Comment
Question by:jagguy
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 22801458
I thought I have used SQL Management Studio with SQL Server 2008 before and on download for Microsoft it takes you to same SMSE as for SQL Server 2005.  Make sure your SQL Server is configured for remote login, you can usually check this from the tools provided under Program Files program group for SQL Server.  There is surface area and configuration manager.  The Configuration Manager will allow you to add a new administrator as well.

Basically, you should be able to connect to the server after it is registered in SMSE with the sa (administrative account) and then you can create database from there.
0
 

Author Comment

by:jagguy
ID: 22801479
ok i just installed sql server 2008 and have the smse 2005.

now what are all the steps i do to configure this (I forget how to configure sql server).

is all i do?
 Make sure your SQL Server is configured for remote login, you can usually check this from the tools provided under Program Files program group for SQL Server.  There is surface area and configuration manager.  The Configuration Manager will allow you to add a new administrator as well.
0
 

Author Comment

by:jagguy
ID: 22802032
all fixed i installed 2005 sql server ex, and 2008 was a bad idea to install in a hurry
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question