Solved

sql server 2008

Posted on 2008-10-24
3
204 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sql to find top3 for each record 7 18
ASP.Net Session State alternatives 3 27
Calculating Business Hours 19 62
Log Backup 2 13
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

705 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now