Solved

sql server 2008

Posted on 2008-10-24
3
217 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 60

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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

626 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