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 Express db in SSMS?

I am using SQL Server 2005 with SQL Server Mgmt Studio. I would like to be
able to connect to a SQL Server Express database within the SSMS. I read on
MS's website that this was possible, but can't figure out how to do it. Is
it possible?
Thanks.
Yes. You may need to enable remote access if you are connecting from
another box and you will probably have to specify the instance name in the
SERVER connection Window in SSMS.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"egraham" <egraham@.discussions.microsoft.com> wrote in message
news:A1EF3F87-4AB7-47FC-9A75-22C2B3312DA4@.microsoft.com...
>I am using SQL Server 2005 with SQL Server Mgmt Studio. I would like to be
> able to connect to a SQL Server Express database within the SSMS. I read
> on
> MS's website that this was possible, but can't figure out how to do it.
> Is
> it possible?
> Thanks.
>

How to connect to SQL Server Express db in SSMS?

I am using SQL Server 2005 with SQL Server Mgmt Studio. I would like to be
able to connect to a SQL Server Express database within the SSMS. I read o
n
MS's website that this was possible, but can't figure out how to do it. Is
it possible?
Thanks.Yes. You may need to enable remote access if you are connecting from
another box and you will probably have to specify the instance name in the
SERVER connection Window in SSMS.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"egraham" <egraham@.discussions.microsoft.com> wrote in message
news:A1EF3F87-4AB7-47FC-9A75-22C2B3312DA4@.microsoft.com...
>I am using SQL Server 2005 with SQL Server Mgmt Studio. I would like to be
> able to connect to a SQL Server Express database within the SSMS. I read
> on
> MS's website that this was possible, but can't figure out how to do it.
> Is
> it possible?
> Thanks.
>

How to connect to SQL Server Express db in SSMS?

I am using SQL Server 2005 with SQL Server Mgmt Studio. I would like to be
able to connect to a SQL Server Express database within the SSMS. I read on
MS's website that this was possible, but can't figure out how to do it. Is
it possible?
Thanks.Yes. You may need to enable remote access if you are connecting from
another box and you will probably have to specify the instance name in the
SERVER connection Window in SSMS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"egraham" <egraham@.discussions.microsoft.com> wrote in message
news:A1EF3F87-4AB7-47FC-9A75-22C2B3312DA4@.microsoft.com...
>I am using SQL Server 2005 with SQL Server Mgmt Studio. I would like to be
> able to connect to a SQL Server Express database within the SSMS. I read
> on
> MS's website that this was possible, but can't figure out how to do it.
> Is
> it possible?
> Thanks.
>

How to connect to SQL server 2005 from C# after default installation?

Hi everyone,

I just installed Visual Studio 2005 and SQL Server 2005. However, I`m not able to connect to the database.

When running this C# code, I get a SqlException.

using System; using System.Data; using System.Data.SqlClient; class Program {

static void Main(string[] args) {

SqlConnection connection = new SqlConnection(); connection.ConnectionString = "Data Source=(local)\\sqlexpress;Initial Catalog=X;Integrated Security=True;"; connection.Open(); connection.Close();

}

}

I get the following error message:

Cannot open database X requested by the login. The login failed.
Login failed for user Y.

Can anyone tell me how to connect to sql server 2005 after default installation? Any help would be appreciated! :-)

Jan

Most likely your user ID does not exist in a list of the logins for the database. You need to grant an access for your Windows account to the database. Check next links with some info

http://support.microsoft.com/kb/325003/en-us#XSLTH4213121122120121120120

http://support.microsoft.com/kb/240872/en-us

|||Thx, my program runs!

I executed the following command (in VS Command Prompt) to add my windows account to the list of database accounts.

C:\>osql -E -S (local)\sqlexpress
1> EXEC sp_grantlogin 'machine_name\user_name'
2> go
1> exit

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 database in SQL Sever Managment Studio

hi

i have created a .aspx page and a sql database in visual studio ,, my question is how can i connect that database in SQL Server Managment Studio?

Just use SqlConnection to refer to any database on SQL Server as you likeYou can start from here:

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(d=ide).aspx

|||

thanks for the answer ,, but i still need some help.. I i have never used the sql managment studio before...the sql database iam trying to connect to is on my harddrive in the App_data folder in my asp project ,,,, when i start SQL Managamenet studio it wants me to enter the

Server Name:

Server Type:

Authentication

so i typ in

Server Type: Database Engien

Authentication: Windows Authenication

Server Name: mycomputer\SQLEXPRESS this is set by defult

so when i click on connect , it connects to the mycomputer\SQLEXPRESS. am i suppose to find my database among the databases that is in the Object Explorer?

this is my connection string that i found in the web.config file

connectionString

="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient"/>

thank you for your help

by the way ,, the reason why i want to connect my to my database in sql management studio is that i want to enable full text search and indexing

|||

To manage database file in Management Studio, you have to 'register' the database file under the App_Data to the SQL instance. We can use detaching/attaching to do this: firstly in VS2005 right click the database file ->choose Detach; then in Management Studio right click Databases-> choose Attach. There are a lot of materials in SQL2005 Books Online, here is a start link:

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

How to connect to AS 2000

Hi all,

Currently I am working on the Window 2003 Enterprise 64-bit with SQL 2005 Enterprise and Visual Studio Professional install. I try to write a console application using Visual Studio to connect to the Analysis Server 2000, but I get the follow error message:

Errorystem.Runtime.InteropServices.COMException (0x800A0E7A): Provider cannot be found. It may not be properly installed.
at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
at ExceptionCheck.Module1.Hodb03_ItemSales() in Z:\Visual Studio\Console\ExceptionCheck\ExceptionCheck\Module1.vb:line 16"

I know if I want to connect to the Analysis Service 2000, I need to install the Microsoft SQL Server 2000 PivotTable Services. After I install the services, I still get the error message.

Thanks,

Tomas

Hi,

Try to re-register msolap (regsvr32 msolap80.dll from "%ProgramFiles%\Common Files\System\Ole DB"). If you get the same error, let's check with the MDX Sample application (ships with AS2000, you can copy it from another machine). If you get the same error, then you probably have corrupted installation of the Pivot Table Service.

|||

Hi,

I tried to re-register msolap, but it didn't help.

|||The MDX Sample application failed with the same error ? Beside re-installing PTS, can't think of something else.

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 connect sql server 2005 cube using visual studio 2005

May i know how to connect sql server 2005 cube using visual studio 2005 ?
May i have some examples and source code to solve this problem ?

Thanks a lot.Please direct these types of questions to the SQL Server Analysis Server forum: http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=83