how to connect to ssis service - The RPC server is unavailable err

Hi
I am trying to connect to ssis service on remote machine using the sql 2005
management studio
I get the following error :
TITLE: Connect to Server
Cannot connect to <servername>.
Connect to SSIS Service on machine "<servername>" failed:
The RPC server is unavailable.
What do I miss please help
Best regards
Meron FridmanDid you figure out a solution ' I have the same problem
--
homebre
----
homebrew's Profile: http://www.dbtalk.net/m5
View this thread: http://www.dbtalk.net/t29008|||I've got the same problem in a two-node active/active environment.
Anyone got any further info?
"homebrew" wrote:
> Did you figure out a solution ' I have the same problem.
>
> --
> homebrew
> ---
> homebrew's Profile: http://www.dbtalk.net/m55
> View this thread: http://www.dbtalk.net/t290084
> .
>|||I found out that one of our developers (developer #1) wasn't having an
problems, and that he had used a different disk to install on hi
desktop. So then developer #2 used his disk, and her problem went away
I had already put in a call to Microsoft, and we tested my RPC port
and they seemed fine. So I think I got a bad disk ... perhaps som
file is corrupted ?
Then he had another utility for me to try, but I haven't bothered yet
since I'm pretty sure it's the disk, and not something on my desktop
--
homebre
----
homebrew's Profile: http://www.dbtalk.net/m5
View this thread: http://www.dbtalk.net/t29008sql

How to connect to SQL Server with ASP.NET

Hi
I need help to connect to SQL server, i got Microsoft Visual Web Developer 2005 Express and SQL Server Management Studio Express
With SQL Server Management Studio Express i can make databases and create tables but i dunno how to connect via asp.net
Anyone could give me a helping hand?
Thanks for the help
- Gucchi

Hi
Following is the sample create_connection method that works for me.Hope this helps you.
ALL THE BEST
Chickoo
Sub create_Conn()

Dim oConnectionAs SqlConnection

Dim DAAs SqlDataAdapter

Dim DSAsNew DataSet

Dim sSQLAsString

Dim sConnAs SqlConnection =New SqlConnection("workstation id=<xxx>;packet size=4096;integrated security=SSPI;data source=<xxx >;persist security info=False;initial catalog=<Database Name>;Trusted_Connection=Yes")

sSQL = " SELECT * FROM MyDatabase"

DA =New SqlDataAdapter(sqlstr, sConn)

DA.Fill(DS, "MyTable")

MyGrid.DataSource = DS

MyGrid.DataBind()

sConn.Close()

EndSub

sql

How to Connect to SQL Server 200 objects

I using VB.NET 2005

I want to connect to my LAN SQL Server 2000 objects

using SMO How I can do that

please any answer

I using SQL Server Management Studio Express CTP

and How I can connect to My LAN SQL Server 2000 Instances

should I write "Computer_name\Instance_name" or What ?

Please My MAIN OBJECTIVE IS TO CONNECT TO SQL Server 2000 Instace ?

You should see all instances through the

EnumAvailableSqlServers

method including the instances from SQL Server 2000.

Computer_name\Instance_name is only needed if you connect to a named instance (either in 2k or 2k5). If you are connecting to a default instance you don′t need the named instance syntax.

HTH, Jens Suessmeyer.

How to connect to my sql server express,also Pubs and northwind for sql server express

1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.
But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHID\SQLEXPRESS".I wants a connection string with respect to this server.
2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.
I have installed sample databases but can't find script for pubs and northwind nor it install automatically.
I wan't to use tutorial's sample.I have resolved the answer of the question's part 1.
Any Help regarding Part 2 ?????

How to Connect to Analysis Services from Client Management Studio?

From my client machine, I have no trouble accessing the Database Engine of my 2005 server in SQL Server Management Studio since I can use SQL Server Authentication. However, Analysis Services (at least how my server is configured right now) only allows Windows Authentication and I can connect. For what it's worth, I can't connect to the Database Engine either on my client using Windows Authentication.

What do I need to do to connect to Analysis Services from my client Management Studio?Like AS2K (and in fact all previous versions of OLAP and Analysis Services), we only support trusted connections from users to AS (both for queries and for administration/operators).

When Analysis Services itself connects to the backend RDBMS, that can be either trusted or SQL logins.

_-_-_ Dave|||

Dave Wickert wrote:

Like AS2K (and in fact all previous versions of OLAP and Analysis Services), we only support trusted connections from users to AS (both for queries and for administration/operators).

When Analysis Services itself connects to the backend RDBMS, that can be either trusted or SQL logins.

_-_-_ Dave

Dave, thanks for the reply. So how do I enable "trusted" logins for AS, if that's possible that is?|||I figured it out.
I had to make an exception for port 2383 (or whatever the default port is for Analysis Services) in Windows Firewall on the Analysis Services server.|||

Dear Dave ,

I am slightly less experienced , and wonder if you could answer some questions for me .

I am running MsSQL2005 and AS on a server .I have built cubes in server .Have had great difficulty in browsing the cube from any remote machine .

Initial problems were associated with the AS server not being able to authenticate the client .

I then put the server and client into the same domain .

I registered an existing user in the domain , into the server users , as member of the various sql groups (olap and other ) .

In the server (AS) user groups , should there be an OLAP administrator group.? I see only an OLAP user group ?

I also granted this domain user login to the sqlserver .

The client is now able to connect to the sqlserver and the Analysis server , using "windows authentication" with one catch .(Previously the cliebnt could connect to the sqlserver using username -pwd authentication .

There are no AS databases listed , no cubes shown etc . The client also has no authority to create a new database in the analysis server .

I am just wondering , what are all the prerequisites to get the client to be able to view the analysis service cubes ?

How can one verify that you have correctly setup the windows authentication required for AS , while you are logged into the server and sql manager ?

What is the correct setting for datasource property ?

Sorry for making such a long story .

any comments appreciated

How to Connect to Analysis Services from Client Management Studio?

From my client machine, I have no trouble accessing the Database Engine of my 2005 server in SQL Server Management Studio since I can use SQL Server Authentication. However, Analysis Services (at least how my server is configured right now) only allows Windows Authentication and I can connect. For what it's worth, I can't connect to the Database Engine either on my client using Windows Authentication.

What do I need to do to connect to Analysis Services from my client Management Studio?
Like AS2K (and in fact all previous versions of OLAP and Analysis Services), we only support trusted connections from users to AS (both for queries and for administration/operators).

When Analysis Services itself connects to the backend RDBMS, that can be either trusted or SQL logins.

_-_-_ Dave|||

Dave Wickert wrote:

Like AS2K (and in fact all previous versions of OLAP and Analysis Services), we only support trusted connections from users to AS (both for queries and for administration/operators).

When Analysis Services itself connects to the backend RDBMS, that can be either trusted or SQL logins.

_-_-_ Dave

Dave, thanks for the reply. So how do I enable "trusted" logins for AS, if that's possible that is?
|||I figured it out.
I had to make an exception for port 2383 (or whatever the default port is for Analysis Services) in Windows Firewall on the Analysis Services server.
|||

Dear Dave ,

I am slightly less experienced , and wonder if you could answer some questions for me .

I am running MsSQL2005 and AS on a server .I have built cubes in server .Have had great difficulty in browsing the cube from any remote machine .

Initial problems were associated with the AS server not being able to authenticate the client .

I then put the server and client into the same domain .

I registered an existing user in the domain , into the server users , as member of the various sql groups (olap and other ) .

In the server (AS) user groups , should there be an OLAP administrator group.? I see only an OLAP user group ?

I also granted this domain user login to the sqlserver .

The client is now able to connect to the sqlserver and the Analysis server , using "windows authentication" with one catch .(Previously the cliebnt could connect to the sqlserver using username -pwd authentication .

There are no AS databases listed , no cubes shown etc . The client also has no authority to create a new database in the analysis server .

I am just wondering , what are all the prerequisites to get the client to be able to view the analysis service cubes ?

How can one verify that you have correctly setup the windows authentication required for AS , while you are logged into the server and sql manager ?

What is the correct setting for datasource property ?

Sorry for making such a long story .

any comments appreciated

How to connect to a server (sql server 2005

Hi Everyone

I'm trying to connect to a server using SQL Server Management studio but I have an error message saying "an error has occurred while establishing a connection to the server" error 1231

I have no knowledge about SQL server 2005 and SQL Server Management studio.

I presume I need to create a server first (but how?)

Could you tell what I need to do do connect to a server?

Many thanks in advance
EmilYou can either setup your own SMS Gateway using a GSM modem connected to a PC, or you can connect to an SMS Gateway provider like http://www.clickatell.com through the Internet, or you can use a combination of both. There are open source gateways like http://www.kannel.org and also commercial gateways like http://www.visualtron.com.

Regards,
Joshua
SMS Server@.Expert

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesn’t allow to make any changes, does anyone have the idea how to make the
change?
Thanks
Wendy
One thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:

>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQL
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up the
>user name and password which is using for local login and gray out, it
>doesnt allow to make any changes, does anyone have the idea how to make the
>change?
>Thanks
>Wendy
|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:

> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
>
>
sql

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesn’t allow to make any changes, does anyone have the idea how to make t
he
change?
Thanks
WendyOne thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:

>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQ
L
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up th
e
>user name and password which is using for local login and gray out, it
>doesnt allow to make any changes, does anyone have the idea how to make th
e
>change?
>Thanks
>Wendy|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:

> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
>
>

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesnâ't allow to make any changes, does anyone have the idea how to make the
change?
Thanks
WendyOne thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:
>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQL
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up the
>user name and password which is using for local login and gray out, it
>doesn?t allow to make any changes, does anyone have the idea how to make the
>change?
>Thanks
>Wendy|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:
> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
> >Hi,
> >
> >I am using the SQL 2005 management studio and trying to connect a remote SQL
> >2005 standard edition server in the mix authentication mode. I need to pick
> >up a different windows user name which existing in remote Server but is not
> >the one I am using to login my local. By default, the connection pick up the
> >user name and password which is using for local login and gray out, it
> >doesnâ't allow to make any changes, does anyone have the idea how to make the
> >change?
> >
> >Thanks
> >
> >Wendy
>

How to connect SQL Server Mangement Console to Adventure Works

This may not be correct request but I have SQL Server Management Studio Express. How do I connect the Adventure Work Database to the console?

How do you use Access to connect to the SQL Server Express?

Thanks for your help.

To connect Management Studio Express to the AdventureWorks database, you need to have SQL Express (or another edition of SQL Server) installed and running that has the AdventureWorks database. You can then connect Management Studio Express to that SQL Server. Note, if you are trying to access SQL Server Express on a remote machine, it needs to be configured for remote access - you can search these forums to a link on a blog.

You can link tables from Access to AdventureWorks. Again, AdventureWorks needs to be running on a version of SQL Server, then you can link the tables using ODBC.

Thanks< MJ

|||Mark,

Thanks for replying but I need more details.

I have SQL 2005 Express. I have downloaded the AdventureWorks database.

I need the steps on how to connect the two together. When I open SQL Server Management Console it does not find Adventure Works. What do I need to do to connect to it.

Also I was able to create a ADP database with Access that resided on my SQL Express Server. At least I was able to see if when I opened the Server Management Console.

What I would like to be able to do is look at the AdventureWorks sample. Once they are connnectd shouldn't I be able to manpulate the data with Access?

Thanks for your help.
Regards,|||Follow the instructions available here to install the AdventureWorks database:
http://msdn2.microsoft.com/library/ms310325.aspx

Thanks< MJ|||

Mark,

Thanks for the reply. The instruction require that I have to use Visual Studio to connect. At this time, I do not want to use Visual Studio. There must be another way to connect AdventureWorks. Can't the SQL Server Management Console connect the AdventureWorks DB?

Thanks

|||

This should work:

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

2. Run SQL Server Management Studio and login to the SQL Express instance (".\SQLExpress" with no quotes should work).

3. In the Object Explorer in SSMS, right click on Databases and select Attach.

4. In the dialog that comes up, click the Add button and browse to the MDF file.

Database should be added and viewable in SSMS. Hope this works!

Thanks, MJ

|||

Hi Mark

I was struggling for 2 days to attach this sample databas i was getting error 602 but could not attach the databse on my local machine but i tried the .\sqlexpress and 2 minutes i had the sample database ready.

This was a great help .. Thanks millions..

Sweety

|||I keep getting a database not found error message.

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

Are these two files created here :

C:\ProgramFiles\MicrosoftSQLServer\MSSQL.\MSSQL\Data\AdventureWorks_Data.mdf

If so i'm missing the AdventureWorks_Data.mdf file ? Or am i?

i followed the instructions where : Http://msdn2.microsoft.com/enus/library/ms310325.aspx

but still the database was not found

|||

The right path to find MDF file c:\ Program Files\Microsoft SQL Server\MSSQL\Data

Note MSSQL not MSSQL.1

|||

Thanks alot Fairy !

They were named "AdventureWorks2000_Data.mdf" and AdventureWorks2000_log.ldf', and located in the folder you specified.

|||

thanks, thats one problem solved but i still have one other.

I've followed the instructions here : http://msdn2.microsoft.com/library/ms310325.aspx as before, and everything went well till.

"To configure AdventureWorks to work with Web server controls"

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'"

My machine name is Leigh, i run win xp home edition, and MS SQL server 2005, so the above command in my case should be :

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N' Leigh\ASPNET'" ? (which doesn't work i assume because not happens )

|||

Mark's instruction is working. Alternatively,

you can use the following script to attach AdventureWorks

database if you install it using default settings.

EXEC sp_attach_db @.dbname = N'AdventureWorks',
@.filename1 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf' ;

How to connect SQL Server Mangement Console to Adventure Works

This may not be correct request but I have SQL Server Management Studio Express. How do I connect the Adventure Work Database to the console?

How do you use Access to connect to the SQL Server Express?

Thanks for your help.

To connect Management Studio Express to the AdventureWorks database, you need to have SQL Express (or another edition of SQL Server) installed and running that has the AdventureWorks database. You can then connect Management Studio Express to that SQL Server. Note, if you are trying to access SQL Server Express on a remote machine, it needs to be configured for remote access - you can search these forums to a link on a blog.

You can link tables from Access to AdventureWorks. Again, AdventureWorks needs to be running on a version of SQL Server, then you can link the tables using ODBC.

Thanks< MJ

|||Mark,

Thanks for replying but I need more details.

I have SQL 2005 Express. I have downloaded the AdventureWorks database.

I need the steps on how to connect the two together. When I open SQL Server Management Console it does not find Adventure Works. What do I need to do to connect to it.

Also I was able to create a ADP database with Access that resided on my SQL Express Server. At least I was able to see if when I opened the Server Management Console.

What I would like to be able to do is look at the AdventureWorks sample. Once they are connnectd shouldn't I be able to manpulate the data with Access?

Thanks for your help.
Regards,
|||Follow the instructions available here to install the AdventureWorks database:
http://msdn2.microsoft.com/library/ms310325.aspx

Thanks< MJ|||

Mark,

Thanks for the reply. The instruction require that I have to use Visual Studio to connect. At this time, I do not want to use Visual Studio. There must be another way to connect AdventureWorks. Can't the SQL Server Management Console connect the AdventureWorks DB?

Thanks

|||

This should work:

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

2. Run SQL Server Management Studio and login to the SQL Express instance (".\SQLExpress" with no quotes should work).

3. In the Object Explorer in SSMS, right click on Databases and select Attach.

4. In the dialog that comes up, click the Add button and browse to the MDF file.

Database should be added and viewable in SSMS. Hope this works!

Thanks, MJ

|||

Hi Mark

I was struggling for 2 days to attach this sample databas i was getting error 602 but could not attach the databse on my local machine but i tried the .\sqlexpress and 2 minutes i had the sample database ready.

This was a great help .. Thanks millions..

Sweety

|||I keep getting a database not found error message.

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

Are these two files created here :

C:\ProgramFiles\MicrosoftSQLServer\MSSQL.\MSSQL\Data\AdventureWorks_Data.mdf

If so i'm missing the AdventureWorks_Data.mdf file ? Or am i?

i followed the instructions where : Http://msdn2.microsoft.com/enus/library/ms310325.aspx

but still the database was not found

|||

The right path to find MDF file c:\ Program Files\Microsoft SQL Server\MSSQL\Data

Note MSSQL not MSSQL.1

|||

Thanks alot Fairy !

They were named "AdventureWorks2000_Data.mdf" and AdventureWorks2000_log.ldf', and located in the folder you specified.

|||

thanks, thats one problem solved but i still have one other.

I've followed the instructions here : http://msdn2.microsoft.com/library/ms310325.aspx as before, and everything went well till.

"To configure AdventureWorks to work with Web server controls"

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'"

My machine name is Leigh, i run win xp home edition, and MS SQL server 2005, so the above command in my case should be :

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N' Leigh\ASPNET'" ? (which doesn't work i assume because not happens )

|||

Mark's instruction is working. Alternatively, you can use the following script to attachAdventureWorks database if you install it using default settings.

EXEC sp_attach_db @.dbname = N'AdventureWorks',
@.filename1 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf' ;

How to connect SQL Server Mangement Console to Adventure Works

This may not be correct request but I have SQL Server Management Studio Express. How do I connect the Adventure Work Database to the console?

How do you use Access to connect to the SQL Server Express?

Thanks for your help.

To connect Management Studio Express to the AdventureWorks database, you need to have SQL Express (or another edition of SQL Server) installed and running that has the AdventureWorks database. You can then connect Management Studio Express to that SQL Server. Note, if you are trying to access SQL Server Express on a remote machine, it needs to be configured for remote access - you can search these forums to a link on a blog.

You can link tables from Access to AdventureWorks. Again, AdventureWorks needs to be running on a version of SQL Server, then you can link the tables using ODBC.

Thanks< MJ

|||Mark,

Thanks for replying but I need more details.

I have SQL 2005 Express. I have downloaded the AdventureWorks database.

I need the steps on how to connect the two together. When I open SQL Server Management Console it does not find Adventure Works. What do I need to do to connect to it.

Also I was able to create a ADP database with Access that resided on my SQL Express Server. At least I was able to see if when I opened the Server Management Console.

What I would like to be able to do is look at the AdventureWorks sample. Once they are connnectd shouldn't I be able to manpulate the data with Access?

Thanks for your help.
Regards,|||Follow the instructions available here to install the AdventureWorks database:
http://msdn2.microsoft.com/library/ms310325.aspx

Thanks< MJ|||

Mark,

Thanks for the reply. The instruction require that I have to use Visual Studio to connect. At this time, I do not want to use Visual Studio. There must be another way to connect AdventureWorks. Can't the SQL Server Management Console connect the AdventureWorks DB?

Thanks

|||

This should work:

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

2. Run SQL Server Management Studio and login to the SQL Express instance (".\SQLExpress" with no quotes should work).

3. In the Object Explorer in SSMS, right click on Databases and select Attach.

4. In the dialog that comes up, click the Add button and browse to the MDF file.

Database should be added and viewable in SSMS. Hope this works!

Thanks, MJ

|||

Hi Mark

I was struggling for 2 days to attach this sample databas i was getting error 602 but could not attach the databse on my local machine but i tried the .\sqlexpress and 2 minutes i had the sample database ready.

This was a great help .. Thanks millions..

Sweety

|||I keep getting a database not found error message.

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

Are these two files created here :

C:\ProgramFiles\MicrosoftSQLServer\MSSQL.\MSSQL\Data\AdventureWorks_Data.mdf

If so i'm missing the AdventureWorks_Data.mdf file ? Or am i?

i followed the instructions where : Http://msdn2.microsoft.com/enus/library/ms310325.aspx

but still the database was not found

|||

The right path to find MDF file c:\ Program Files\Microsoft SQL Server\MSSQL\Data

Note MSSQL not MSSQL.1

|||

Thanks alot Fairy !

They were named "AdventureWorks2000_Data.mdf" and AdventureWorks2000_log.ldf', and located in the folder you specified.

|||

thanks, thats one problem solved but i still have one other.

I've followed the instructions here : http://msdn2.microsoft.com/library/ms310325.aspx as before, and everything went well till.

"To configure AdventureWorks to work with Web server controls"

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'"

My machine name is Leigh, i run win xp home edition, and MS SQL server 2005, so the above command in my case should be :

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N' Leigh\ASPNET'" ? (which doesn't work i assume because not happens )

|||

Mark's instruction is working. Alternatively,

you can use the following script to attach AdventureWorks

database if you install it using default settings.

EXEC sp_attach_db @.dbname = N'AdventureWorks',
@.filename1 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf' ;sql

How to connect SQL Server Mangement Console to Adventure Works

This may not be correct request but I have SQL Server Management Studio Express. How do I connect the Adventure Work Database to the console?

How do you use Access to connect to the SQL Server Express?

Thanks for your help.

To connect Management Studio Express to the AdventureWorks database, you need to have SQL Express (or another edition of SQL Server) installed and running that has the AdventureWorks database. You can then connect Management Studio Express to that SQL Server. Note, if you are trying to access SQL Server Express on a remote machine, it needs to be configured for remote access - you can search these forums to a link on a blog.

You can link tables from Access to AdventureWorks. Again, AdventureWorks needs to be running on a version of SQL Server, then you can link the tables using ODBC.

Thanks< MJ

|||Mark,

Thanks for replying but I need more details.

I have SQL 2005 Express. I have downloaded the AdventureWorks database.

I need the steps on how to connect the two together. When I open SQL Server Management Console it does not find Adventure Works. What do I need to do to connect to it.

Also I was able to create a ADP database with Access that resided on my SQL Express Server. At least I was able to see if when I opened the Server Management Console.

What I would like to be able to do is look at the AdventureWorks sample. Once they are connnectd shouldn't I be able to manpulate the data with Access?

Thanks for your help.
Regards,
|||Follow the instructions available here to install the AdventureWorks database:
http://msdn2.microsoft.com/library/ms310325.aspx

Thanks< MJ|||

Mark,

Thanks for the reply. The instruction require that I have to use Visual Studio to connect. At this time, I do not want to use Visual Studio. There must be another way to connect AdventureWorks. Can't the SQL Server Management Console connect the AdventureWorks DB?

Thanks

|||

This should work:

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

2. Run SQL Server Management Studio and login to the SQL Express instance (".\SQLExpress" with no quotes should work).

3. In the Object Explorer in SSMS, right click on Databases and select Attach.

4. In the dialog that comes up, click the Add button and browse to the MDF file.

Database should be added and viewable in SSMS. Hope this works!

Thanks, MJ

|||

Hi Mark

I was struggling for 2 days to attach this sample databas i was getting error 602 but could not attach the databse on my local machine but i tried the .\sqlexpress and 2 minutes i had the sample database ready.

This was a great help .. Thanks millions..

Sweety

|||I keep getting a database not found error message.

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

Are these two files created here :

C:\ProgramFiles\MicrosoftSQLServer\MSSQL.\MSSQL\Data\AdventureWorks_Data.mdf

If so i'm missing the AdventureWorks_Data.mdf file ? Or am i?

i followed the instructions where : Http://msdn2.microsoft.com/enus/library/ms310325.aspx

but still the database was not found

|||

The right path to find MDF file c:\ Program Files\Microsoft SQL Server\MSSQL\Data

Note MSSQL not MSSQL.1

|||

Thanks alot Fairy !

They were named "AdventureWorks2000_Data.mdf" and AdventureWorks2000_log.ldf', and located in the folder you specified.

|||

thanks, thats one problem solved but i still have one other.

I've followed the instructions here : http://msdn2.microsoft.com/library/ms310325.aspx as before, and everything went well till.

"To configure AdventureWorks to work with Web server controls"

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'"

My machine name is Leigh, i run win xp home edition, and MS SQL server 2005, so the above command in my case should be :

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N' Leigh\ASPNET'" ? (which doesn't work i assume because not happens )

|||

Mark's instruction is working. Alternatively, you can use the following script to attach AdventureWorks database if you install it using default settings.

EXEC sp_attach_db @.dbname = N'AdventureWorks',
@.filename1 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf' ;

How to clear table?

Is there a way to clear all the records in a table in Microsoft SQLServer Management Studio instead of selecting all the rows and delete?

Try the link below and Truncate the table. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms177570.aspx

|||Thanks for the response, but I'm not looking for a code clear records.I am in Microsof SQL Management Studio. How do I clear the table withinthis tool?|||

Assuming no constraint defined on the table try the link below for a walkthrough. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms175491.aspx

|||That instruction only show how to delete a column. Are you suggestingthat deleting the column and then recreate that same column?|||

Sorry wrong link.

http://msdn2.microsoft.com/en-us/library/ms190616.aspx

|||That link shows how to delete the whole tabe. I don't want to deletethe whole table. All I want is to clear all the records in the table. Idon't want to recreate the whole table again.|||Truncate is the clean way to do it or you have to do it by column because a database table is columns with your data in rows so if you don't want to truncate you have to do it by column.|||The reason I asked about clearing the table records is because inphpMyAdmin with MySQL, it is very simple to clear the whole records ina table. I would be very surprise if Microsoft does not have thisfeature in their MS SQL Management Studio tool.|||

MySQL is generally free so you can do crude things but SQL Server cost a lot of money companies will not like data delete operations that cannot be traced. So the links below explain Truncate and Delete very clearly and some solutions using temp table. Hope this helps.

http://codebetter.com/blogs/raymond.lewallen/archive/2005/05/09/62960.aspx

http://www.sql-server-performance.com/q&a118.asp

|||Thanks! I will give those two links some reading.