Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

sql server 2008

Posted on 2008-10-24
3
Medium Priority
?
219 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 2000 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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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.
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

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