how to create sql server 2005 instance(after uninstalling sql server express)

I have uninsttaled sql server 2005 express then installed sql server 2005 developer edition.All things are installed and working fine like management studio,BOL,reporting services ,e.t.c.

But there is no instance of sql server 2005.I can connect to sql server 2000 instance from management studio.

I have check from all ways but there isn't any instance.

Could I create a instance of sql server 2005 from some where if yes the how.

You can also check my post at sqlteam forum http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63600

If you run setup again you can create another instance of SQL Server on the same machine. Just give it a new instance name when you run setup.

|||

Thanks Alexander.

I achieve it exactly the same way a week earlier.What I were trying to find is that is there any way we can create an instance without reinstalling full sql server 2005.As at that time when there isn't any instance but i can connect from management studion to sql server 2000.

|||No You need to go through installation again to install a new instance. For speed you can limit what you install to only a new DB Engine which is quicker than installing all the sql server 2005 components again.|||

Thanks alexander.

That indeed increased my knowledge

how to create new login account in MS-SQL Server 2005 Express Edition?

Hi all,

I am new to MS SQL Server.
I have downloaded and installed SQL Server 2005 Express Edition.

I am just learning database programming with this.

But when I read MSDN documents - role, user-name, login-name confuses me.

I tried as following,
1. create database 'eg_database'
2. exec sp_addlogin 'eg_login', 'eg_loginpasswd', 'eg_database'
3. exec sp_adduser 'eg_login', 'eg_user'
after these 3 steps, I tried
sqlcmd -S .\SQLExpress -U 'eg_login'
I was asked for pass word and entered correctly. But I get error only.

Password: Msg 4064, Level 11, State 1, Server SYS1\SQLEXPRESS, Line 1
Cannot open user default database. Login failed.
Msg 18456, Level 14, State 1, Server SURASYS1\SQLEXPRESS, Line 1
Login failed for user 'eg_login'.

What I want to know is,
1. I want to create one new database
2. a new user account to access that database with table create, select, update, delete, alter, insert permission.
3. Any server permissions/configurations have to be done to access from another machine in network? or simply "sqlcmd -S sys1\SQLExpress -U username -P password " (how to specify IP address in this syntax instead system name(i.e. sys1).

pls guide me with steps to finish the above things.

Regards,
Purusothaman A
Finally I found answers for my questions 1 and 2 with the help of MS SQL Server Management Studio Express.

CREATE DATABASE [db1] ON PRIMARY
( NAME = N'db1', FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\db1.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N'db1_log', FILENAME = N'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\db1_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)
GO

USE [master]
GO
CREATE LOGIN [db1_user] WITH PASSWORD=N'db1_passwd', DEFAULT_DATABASE=[db1], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [db1]
GO
CREATE USER [db1_user] FOR LOGIN [db1_user]
GO

Still searching answer for question 3.

Regards,
Purusothaman A
sql

How to create databases in SQL Express

Autofreak wrote:

Hi All,

I have installed the SQL Server 2005 Express edition and its running fine.

I like to connect to the server and create database. Should I do it

through command prompt only or any tool is available like

Enterprise manager for this ?

You can use SQL Server Express Managment Studio which can be downloaded from here:

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

How to create Database Diagrams in SQL Server Management Studio?

Hi:

I installed SQL Server 2005 onto Vista RTM.

When launched SQL Server Mangement Studio -> Databases -> choose a database and expand.

Right click on top of "Database Diagrams" node, only options I've got are:

1. Working with SQL Server 2000 Diagram

2. Refresh.

Wondering did I missing something on my system in order to make database diagrams to work?

Thanks

Tommy

Only SQL Server 2005 with SP2 will be supported on Vista and Longhorn. You can install the latest SP2 CTP to see if your issue is fixed or not. See http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx for more info.

You can download SP2 CTP from here: http://support.microsoft.com/kb/913089/.

|||I have the same problem as mentioned above, only I have SQL Server 2005 installed under XP. I right-click any Database Diagrams node and the only options are 'Working with SQL Server 2000 diagrams' and 'Refresh'. No option for creating a new diagram. I have installed SP2 for SQL Server 2005 to no avail. Does anyone have a solution for this problem?

How to create Database Diagrams in SQL Server Management Studio?

Hi:

I installed SQL Server 2005 onto Vista RTM.

When launched SQL Server Mangement Studio -> Databases -> choose a database and expand.

Right click on top of "Database Diagrams" node, only options I've got are:

1. Working with SQL Server 2000 Diagram

2. Refresh.

Wondering did I missing something on my system in order to make database diagrams to work?

Thanks

Tommy

Only SQL Server 2005 with SP2 will be supported on Vista and Longhorn. You can install the latest SP2 CTP to see if your issue is fixed or not. See http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx for more info.

You can download SP2 CTP from here: http://support.microsoft.com/kb/913089/.

|||I have the same problem as mentioned above, only I have SQL Server 2005 installed under XP. I right-click any Database Diagrams node and the only options are 'Working with SQL Server 2000 diagrams' and 'Refresh'. No option for creating a new diagram. I have installed SP2 for SQL Server 2005 to no avail. Does anyone have a solution for this problem?

how to create an additional sql server 2005 named instance

If i initially installed SQL Server 2005 Developer Edition using the "default instance", how do i create an additional (new) SQL Server 2005 (90) "named instance" without reinstalling SQL Server 2005?

Each instance of SQL Server is a new installation. The first installation is default, after this, all others installations will be named instance. It′s simple, run again the instalation and choise named instance. What is your doubt ?

How to create a Virtual Directory that uses instance name

Hi,
I installed Reporting Services 2005 as an instance MYMACHINE\RS2005. If I do
this, the regular setup creates a Virtual Directory called
http://MYMACHINE/ReportServer$RS2005/
But if I wanted to create a similar virtual directory (say
http://MYMACHINE/TestServer$RS2005) using Reporting Services Configuration
tool, it errors out saying the virtual directory name is invalid (I just type
in TestServer$RS2005 in the virtual directory name)
How can I accomplish this?
Any help is greatly appreciated.
Thanks.Also,
I just found documentation on MSDN that said that the tool will
automatically add the instance name, but when I use the tool, it just creates
a Virtual Directory called TestServer.
"Raghu" wrote:
> Hi,
> I installed Reporting Services 2005 as an instance MYMACHINE\RS2005. If I do
> this, the regular setup creates a Virtual Directory called
> http://MYMACHINE/ReportServer$RS2005/
> But if I wanted to create a similar virtual directory (say
> http://MYMACHINE/TestServer$RS2005) using Reporting Services Configuration
> tool, it errors out saying the virtual directory name is invalid (I just type
> in TestServer$RS2005 in the virtual directory name)
> How can I accomplish this?
> Any help is greatly appreciated.
> Thanks.

How to create a SQL 2005 Database

I have installed VBX and SQLX and have written a few programs. Now, I want to evaluate SQL 2005. I installed it and...

How do I create a SQL 2005 database in VBX?

Also, in the IDE, I don't see anything labeled "SQLX" in VBX... everything is SQL 2005, but I still think its SQLX and not SQL2005.

Very confused... .

Thanks.

Am I hearing correctly... that VBX cannot work with SQL2005... you must use SQLX?

Then I had someone tell me there's no difference with VBX and VB2005...

The only problem with SQLX is that... should you be adding records to the DB and it exceeds 4GB, it's going to crash and should you even use multiple DBs, you may have to search through all your mini DBs to find all the records you need. And then you probably need one extra DB just to list which records are in which DB...

Just imagine if you have to query the DBs to find the records that may match and then query the Dataset to get the records that do... per DB... that's just a performance disaster. Not the way to teach people how to program.

That's just not cool dude!

|||VBX doesn't support SQL2005.

How to create a new SQL2005 DB?

Hi folks,

i have VSTS installed and TFS beta refresh 3. all is working fine.

How can i use Visual Studio 2005 to create a new database on the remote server? i can connecto to it fine using the 'server explorer' tab .. but of course it only lists databases that currently exist. How can i create a new one?

lastly, i have no installed sql2005 express edition or whatever it is called LOCALLY on my machine. the reason i didn't do this is becuase i was hoping to use the enterprise sql 2005 server.

If your are using the SQLExpress version best thing to do is download and install the SQLExpress Management Studio CTP from microsoft. It basically gives you the same functionality that is in the full SQL2005 versions.

After running the studio and connecting to the database engine you can navigate to the databases node, right click, new, Database then begin configuring all your tables, constraints and security.

The management studio CTP can be had herehttp://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en

|||

Ahh! so this Management Studio is the equivalent to the SQL CLIENT TOOLS for our sql server 2000's?

is there a Management Studio for sql2005? is it found on the sql2005 cd or do we download it?

|||The SQL Management Studio is installed by default in all versions of SQL2005, Eval, Std, Dev and Enterprise. it can be found in Start--All Programs--Microsoft SQL Server 2005--SQL Server Management Studio. The CTP version can be used to connect to any SQL2005 instance on the network. Just choose the Server/Instance from the drop down list in the Connect to Database engine dialogue or manually type the server/instance name.|||

ahh, interesting.

i installed Team Foundation Server beta refresh 3. Part of that is the SQL2005 install. I installed my SQL2005 version using the MS provided UNATTENDED INSTALL file. This file must have excluded the management studio! damn :(

that said, what about clients trying to manage a sql server, where the sqlserver is remote. Are there client tools on the SQL2005 CD?

How to create a new instance with SQL 2005

Someone else installed SQL 2005 on the server and I am now trying to create
a new instance.
The documention seems to be pointing me to the setup CD to do this. However,
the only
options to install are the client tools and samples. It never mentions
anything about creating
a new instance.
When going through the "Control Panel" and clicking on the "Change" button
for SQL 2005
it does have a link to click on called "To install a new component, click
here". But all this
link does is start the same setup again, which doesn't mention anything
about creating a new
instance.
The version of SQL is 2005 standard. the CD has two folders, "Servers" and
"Tools".
Each have a setup.exe in them, but both seem to be the same exact program.
Does anyone know how to do this?
Thanks
JeffYes you would use the CD. Disk 1 (or the Server Folder)
should have a SQLRun.msi that you would execute from the
Setup Directory.
Select SQL Server Database Services from the setup screen
after the prerequisite checks run. An instance name screen
comes up a screen or two later - I think after the Feature
selection screen. From there you select Named Instance.
-Sue
On Mon, 2 Oct 2006 16:22:30 -0500, "JD" <summer79@.gte.net>
wrote:

>Someone else installed SQL 2005 on the server and I am now trying to create
>a new instance.
>The documention seems to be pointing me to the setup CD to do this. However
,
>the only
>options to install are the client tools and samples. It never mentions
>anything about creating
>a new instance.
>When going through the "Control Panel" and clicking on the "Change" button
>for SQL 2005
>it does have a link to click on called "To install a new component, click
>here". But all this
>link does is start the same setup again, which doesn't mention anything
>about creating a new
>instance.
>The version of SQL is 2005 standard. the CD has two folders, "Servers" and
>"Tools".
>Each have a setup.exe in them, but both seem to be the same exact program.
>Does anyone know how to do this?
>Thanks
>Jeff
>

How to create a new instance with SQL 2005

Someone else installed SQL 2005 on the server and I am now trying to create
a new instance.
The documention seems to be pointing me to the setup CD to do this. However,
the only
options to install are the client tools and samples. It never mentions
anything about creating
a new instance.
When going through the "Control Panel" and clicking on the "Change" button
for SQL 2005
it does have a link to click on called "To install a new component, click
here". But all this
link does is start the same setup again, which doesn't mention anything
about creating a new
instance.
The version of SQL is 2005 standard. the CD has two folders, "Servers" and
"Tools".
Each have a setup.exe in them, but both seem to be the same exact program.
Does anyone know how to do this?
Thanks
Jeff
Yes you would use the CD. Disk 1 (or the Server Folder)
should have a SQLRun.msi that you would execute from the
Setup Directory.
Select SQL Server Database Services from the setup screen
after the prerequisite checks run. An instance name screen
comes up a screen or two later - I think after the Feature
selection screen. From there you select Named Instance.
-Sue
On Mon, 2 Oct 2006 16:22:30 -0500, "JD" <summer79@.gte.net>
wrote:

>Someone else installed SQL 2005 on the server and I am now trying to create
>a new instance.
>The documention seems to be pointing me to the setup CD to do this. However,
>the only
>options to install are the client tools and samples. It never mentions
>anything about creating
>a new instance.
>When going through the "Control Panel" and clicking on the "Change" button
>for SQL 2005
>it does have a link to click on called "To install a new component, click
>here". But all this
>link does is start the same setup again, which doesn't mention anything
>about creating a new
>instance.
>The version of SQL is 2005 standard. the CD has two folders, "Servers" and
>"Tools".
>Each have a setup.exe in them, but both seem to be the same exact program.
>Does anyone know how to do this?
>Thanks
>Jeff
>

How to create a new instance with SQL 2005

Someone else installed SQL 2005 on the server and I am now trying to create
a new instance.
The documention seems to be pointing me to the setup CD to do this. However,
the only
options to install are the client tools and samples. It never mentions
anything about creating
a new instance.
When going through the "Control Panel" and clicking on the "Change" button
for SQL 2005
it does have a link to click on called "To install a new component, click
here". But all this
link does is start the same setup again, which doesn't mention anything
about creating a new
instance.
The version of SQL is 2005 standard. the CD has two folders, "Servers" and
"Tools".
Each have a setup.exe in them, but both seem to be the same exact program.
Does anyone know how to do this?
Thanks
JeffYes you would use the CD. Disk 1 (or the Server Folder)
should have a SQLRun.msi that you would execute from the
Setup Directory.
Select SQL Server Database Services from the setup screen
after the prerequisite checks run. An instance name screen
comes up a screen or two later - I think after the Feature
selection screen. From there you select Named Instance.
-Sue
On Mon, 2 Oct 2006 16:22:30 -0500, "JD" <summer79@.gte.net>
wrote:
>Someone else installed SQL 2005 on the server and I am now trying to create
>a new instance.
>The documention seems to be pointing me to the setup CD to do this. However,
>the only
>options to install are the client tools and samples. It never mentions
>anything about creating
>a new instance.
>When going through the "Control Panel" and clicking on the "Change" button
>for SQL 2005
>it does have a link to click on called "To install a new component, click
>here". But all this
>link does is start the same setup again, which doesn't mention anything
>about creating a new
>instance.
>The version of SQL is 2005 standard. the CD has two folders, "Servers" and
>"Tools".
>Each have a setup.exe in them, but both seem to be the same exact program.
>Does anyone know how to do this?
>Thanks
>Jeff
>

How to create a new failover cluster

At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios nameI found the step on msdn . thanks
http://msdn.microsoft.com/library/d...
ering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> glsD:%23a6HuVc8GHA.4572@.TK2MSFTN
GP02.phx.gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>

How to create a new failover cluster

At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios name
I found the step on msdn . thanks
http://msdn.microsoft.com/library/de...ering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> glsD:%23a6HuVc8GHA.4572@.TK2MSFTNGP02.phx .gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>

How to create a new failover cluster

At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios name
.
.
.
.
Fail screen
is the steps correct ?
Regards,
WilliamI found the step on msdn . thanks
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_clustering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> ¼¶¼g©ó¶l¥ó·s»D:%23a6HuVc8GHA.4572@.TK2MSFTNGP02.phx.gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>

how to create a mdf db with sql server 2005 ctp?

hi,

i have installed the sql server 2005 ctp cause i couldn't install the sql server 2005 express on my computer. when i now create a database under the sql server 2005 management studio and connect from vs 2005 beta1 everything works fine for me.

but i want to create and work with the single mdf files wich are created by sql server express edition via ADD NEW ITEM -> DATABASE -> DB.MDF .

is it possible to create such a db file for xcopy deploayment use?

thanks
Yavuz BogazciYavuz,

The functionality you speak of is only available with SQL Server Express. What problems did you encounter while installing Express?

Dan

How to create a database on MS SQL Server Desktop Engine

Dear friends,

Can anybody give me some piece of information about creating a database on SQL Server Desktop Engine.

I have installed MSDE 2000 (Rel A) on my system running Win 2000 Prof. The SQL Server icon is now visible on my taskpar with green arrow showing 'Running - \\ALI-LAPTOP' But I want to use it to accomodate my database currently in Access. I have tried to use Upsizing Wizard to create new database on it but it is giving this error (Login failed for user 'sa' (with password 'sa'). Not associated with a trusted SQL Server connection.)

I was also not able to connect it with ODBC.

Can you please help me even if seems to be setup problem. Because, the MSDE setup completed successfully with a good system restart.

Regards,
Zulfiqar AliBased on your description you are not providing the correct password for the SA account, or you are not using Mixed Mode authentication. You need to know which Authentication method you enabled when you installed MSDE to know how to log in.
Let’s assume you didn’t specify anything, then you are using Windows Authentication and the SA account isn’t enabled. In that case, the Upsize Wizard in Access will only work if you choose the option to use Windows Authentication when choosing your database. If you want to create a database without using the Upsize Wizard, you can do that using oSQL to run a CREATE DATABASE statement.
More information about oSQL: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp
Help on CREATE DATABASE statement: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp?frame=true
If you are using Mixed Mode authentication you should be able to log in using an appropriate User/Password combination. Make sure you are using the right password for your SA account, you would have had to set the password when you installed MSDE.
Hope this helps,

Mike

How to creat a first DB?

Hello all,

I've Installed VS2005 and MSSQL express with it. I used to work with mssql 2003 enterprise edition where it had "Enterprise Manager" from which I could create and modify my Databases.

How do I creat a new database with MSSQL express?

I've tried to do this via visual studio 2005 "server explorer". I"m entering the "Create new SQL Server Database" dialog, I select my server's name and my new database name and I recive an error message which says "An error has occurred while estabilishing a connection to the server" and it also says that

"When connecting to SQL server 2005, this failure may be caused by the fact that under the defult settings SQL sever does not allow remote connections".

How do configure my MSSQL express to allow the remote connection?

Thanks in advance!

With the new SQL 2005 systems you need to use the new Management Studio to perform the same tasks as the Older Enterprise Manager and Query tools. With the full versions this is included, for the basic express product you can get a smaller version from the Microsoft Downloads site, Called SQL Management Studio Express.

In the case of remote connections have a look at this support article... http://support.microsoft.com/default.aspx/kb/914277

|||

How to configure SQL Server 2005 to allow remote connections

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

|||Thanks a lot guys :)|||

Hi,

also have a look at the screencast section on my site, which will show you a walkthrough for your problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

How to crearte database in MSDE

Ihave installed the MSDE from Office 2002 CD and MSDE is running. I can see the SQL Server Icon in tray with green arrow. CAn ne body help me how to create database in the MSDE. I am new to this. Is there any query manager or entrprise tool by which I can create database and table in it. Also I am not able ro install the Starter Kit .

Please help me in this.Answered here:http://forums.asp.net/1062587/ShowPost.aspx#1062587