[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

sql server 2008

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
jagguy
Asked:
jagguy
  • 2
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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
 
jagguyAuthor Commented:
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
 
jagguyAuthor Commented:
all fixed i installed 2005 sql server ex, and 2008 was a bad idea to install in a hurry
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now