Can any of you guys help?
I am new to using SQL Server. I have a database that I wish to upsize from
Access to put the back end on a server, and use Access as a front-end.
However, I am stuck at the very first stage - I cannot link Access to the
SQL server.

I am using SQL Server Management Studio on a single computer for development
purposes, no network involved yet.
In Access 2010 beta, when I try External Data / ODBC / Link, then I am
presented with the Select Data Source dialog. I click on New at the DSN Name
field, and select SQL Server, then type in a name fro the new data source,
and Finish. I then get another dialog 'Create a New Data Source to SQL
Server', where I type in a description and select (local) for the server to
connect to, and choose Windows authentication. This is where my problem
arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17, SQL
Serverdoes not exist or access denied'

I am sure this is a pretty basic problem - can anyone tell me where I need
to turn next?

Stephen

Additional info: I have already created an SQL database with all the table I
need, I just cannot connect to it from within Access.

Stephen


"Stephen Raftery" wrote:

> Can any of you guys help?
> I am new to using SQL Server. I have a database that I wish to upsize from
> Access to put the back end on a server, and use Access as a front-end.
> However, I am stuck at the very first stage - I cannot link Access to the
> SQL server.
>
> I am using SQL Server Management Studio on a single computer for development
> purposes, no network involved yet.
> In Access 2010 beta, when I try External Data / ODBC / Link, then I am
> presented with the Select Data Source dialog. I click on New at the DSN Name
> field, and select SQL Server, then type in a name fro the new data source,
> and Finish. I then get another dialog 'Create a New Data Source to SQL
> Server', where I type in a description and select (local) for the server to
> connect to, and choose Windows authentication. This is where my problem
> arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17, SQL
> Serverdoes not exist or access denied'
>
> I am sure this is a pretty basic problem - can anyone tell me where I need
> to turn next?
>
> Stephen
>

When you created your table in SQL-Server, did you set permissions?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

<Stephen> wrote in message
news:1ED9008F-A3B2-4633-839B-(E-Mail Removed)...
> Additional info: I have already created an SQL database with all the table
> I
> need, I just cannot connect to it from within Access.
>
> Stephen
>
>
> "Stephen Raftery" wrote:
>
>> Can any of you guys help?
>> I am new to using SQL Server. I have a database that I wish to upsize
>> from
>> Access to put the back end on a server, and use Access as a front-end.
>> However, I am stuck at the very first stage - I cannot link Access to the
>> SQL server.
>>
>> I am using SQL Server Management Studio on a single computer for
>> development
>> purposes, no network involved yet.
>> In Access 2010 beta, when I try External Data / ODBC / Link, then I am
>> presented with the Select Data Source dialog. I click on New at the DSN
>> Name
>> field, and select SQL Server, then type in a name fro the new data
>> source,
>> and Finish. I then get another dialog 'Create a New Data Source to SQL
>> Server', where I type in a description and select (local) for the server
>> to
>> connect to, and choose Windows authentication. This is where my problem
>> arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17,
>> SQL
>> Serverdoes not exist or access denied'
>>
>> I am sure this is a pretty basic problem - can anyone tell me where I
>> need
>> to turn next?
>>
>> Stephen
>>

Stephen,

In addition to Jeff's reply... the Server also has to be running when you
try to connect to it.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

<Stephen> wrote in message
news:1ED9008F-A3B2-4633-839B-(E-Mail Removed)...
Additional info: I have already created an SQL database with all the table I
need, I just cannot connect to it from within Access.

Stephen


"Stephen Raftery" wrote:

> Can any of you guys help?
> I am new to using SQL Server. I have a database that I wish to upsize from
> Access to put the back end on a server, and use Access as a front-end.
> However, I am stuck at the very first stage - I cannot link Access to the
> SQL server.
>
> I am using SQL Server Management Studio on a single computer for
> development
> purposes, no network involved yet.
> In Access 2010 beta, when I try External Data / ODBC / Link, then I am
> presented with the Select Data Source dialog. I click on New at the DSN
> Name
> field, and select SQL Server, then type in a name fro the new data source,
> and Finish. I then get another dialog 'Create a New Data Source to SQL
> Server', where I type in a description and select (local) for the server
> to
> connect to, and choose Windows authentication. This is where my problem
> arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17, SQL
> Serverdoes not exist or access denied'
>
> I am sure this is a pretty basic problem - can anyone tell me where I need
> to turn next?
>
> Stephen
>

No I did not set any permissions: where do I do that?
The database was created using SQL Server Management Studio: does that have
to be running as well?


Stephen



"Gina Whipp" wrote:

> Stephen,
>
> In addition to Jeff's reply... the Server also has to be running when you
> try to connect to it.
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> <Stephen> wrote in message
> news:1ED9008F-A3B2-4633-839B-(E-Mail Removed)...
> Additional info: I have already created an SQL database with all the table I
> need, I just cannot connect to it from within Access.
>
> Stephen
>
>
> "Stephen Raftery" wrote:
>
> > Can any of you guys help?
> > I am new to using SQL Server. I have a database that I wish to upsize from
> > Access to put the back end on a server, and use Access as a front-end.
> > However, I am stuck at the very first stage - I cannot link Access to the
> > SQL server.
> >
> > I am using SQL Server Management Studio on a single computer for
> > development
> > purposes, no network involved yet.
> > In Access 2010 beta, when I try External Data / ODBC / Link, then I am
> > presented with the Select Data Source dialog. I click on New at the DSN
> > Name
> > field, and select SQL Server, then type in a name fro the new data source,
> > and Finish. I then get another dialog 'Create a New Data Source to SQL
> > Server', where I type in a description and select (local) for the server
> > to
> > connect to, and choose Windows authentication. This is where my problem
> > arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17, SQL
> > Serverdoes not exist or access denied'
> >
> > I am sure this is a pretty basic problem - can anyone tell me where I need
> > to turn next?
> >
> > Stephen
> >

I have tried linking while the SQL Studio is open: no joy there.
I cannot find any option to alter Permissions: where would that be?

Stephen


"Gina Whipp" wrote:

> Stephen,
>
> In addition to Jeff's reply... the Server also has to be running when you
> try to connect to it.
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> <Stephen> wrote in message
> news:1ED9008F-A3B2-4633-839B-(E-Mail Removed)...
> Additional info: I have already created an SQL database with all the table I
> need, I just cannot connect to it from within Access.
>
> Stephen
>
>
> "Stephen Raftery" wrote:
>
> > Can any of you guys help?
> > I am new to using SQL Server. I have a database that I wish to upsize from
> > Access to put the back end on a server, and use Access as a front-end.
> > However, I am stuck at the very first stage - I cannot link Access to the
> > SQL server.
> >
> > I am using SQL Server Management Studio on a single computer for
> > development
> > purposes, no network involved yet.
> > In Access 2010 beta, when I try External Data / ODBC / Link, then I am
> > presented with the Select Data Source dialog. I click on New at the DSN
> > Name
> > field, and select SQL Server, then type in a name fro the new data source,
> > and Finish. I then get another dialog 'Create a New Data Source to SQL
> > Server', where I type in a description and select (local) for the server
> > to
> > connect to, and choose Windows authentication. This is where my problem
> > arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17, SQL
> > Serverdoes not exist or access denied'
> >
> > I am sure this is a pretty basic problem - can anyone tell me where I need
> > to turn next?
> >
> > Stephen
> >

Stephen,

Before we get to the permissions issue (and the answer to the the question
will answer the permissions issue)... Opening SQL Server Management Studio
does not mean the database is *running*. Please go to the the Database
folder and navigate to your database and double click... what happens? AND
when you open SSMS do you get a prompt to log on?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

<Stephen> wrote in message
news:64E86A8B-8BBB-4A0B-B286-(E-Mail Removed)...
I have tried linking while the SQL Studio is open: no joy there.
I cannot find any option to alter Permissions: where would that be?

Stephen


"Gina Whipp" wrote:

> Stephen,
>
> In addition to Jeff's reply... the Server also has to be running when you
> try to connect to it.
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> <Stephen> wrote in message
> news:1ED9008F-A3B2-4633-839B-(E-Mail Removed)...
> Additional info: I have already created an SQL database with all the table
> I
> need, I just cannot connect to it from within Access.
>
> Stephen
>
>
> "Stephen Raftery" wrote:
>
> > Can any of you guys help?
> > I am new to using SQL Server. I have a database that I wish to upsize
> > from
> > Access to put the back end on a server, and use Access as a front-end.
> > However, I am stuck at the very first stage - I cannot link Access to
> > the
> > SQL server.
> >
> > I am using SQL Server Management Studio on a single computer for
> > development
> > purposes, no network involved yet.
> > In Access 2010 beta, when I try External Data / ODBC / Link, then I am
> > presented with the Select Data Source dialog. I click on New at the DSN
> > Name
> > field, and select SQL Server, then type in a name fro the new data
> > source,
> > and Finish. I then get another dialog 'Create a New Data Source to SQL
> > Server', where I type in a description and select (local) for the server
> > to
> > connect to, and choose Windows authentication. This is where my problem
> > arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17,
> > SQL
> > Serverdoes not exist or access denied'
> >
> > I am sure this is a pretty basic problem - can anyone tell me where I
> > need
> > to turn next?
> >
> > Stephen
> >

Ah, I get you.
When I click on the database file, I get the message
'Windows cannot open the file 'Rotamaster.sdf'
To open it, Windows needs to know the program you want to use to open it.
What do you want to do:
@ Use the Web Service to find the corre nt program
@Select a program from a list of installed programs.


Does this shed some light?

Stephen


"Gina Whipp" wrote:

> Stephen,
>
> Before we get to the permissions issue (and the answer to the the question
> will answer the permissions issue)... Opening SQL Server Management Studio
> does not mean the database is *running*. Please go to the the Database
> folder and navigate to your database and double click... what happens? AND
> when you open SSMS do you get a prompt to log on?
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> <Stephen> wrote in message
> news:64E86A8B-8BBB-4A0B-B286-(E-Mail Removed)...
> I have tried linking while the SQL Studio is open: no joy there.
> I cannot find any option to alter Permissions: where would that be?
>
> Stephen
>
>
> "Gina Whipp" wrote:
>
> > Stephen,
> >
> > In addition to Jeff's reply... the Server also has to be running when you
> > try to connect to it.
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" - Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > <Stephen> wrote in message
> > news:1ED9008F-A3B2-4633-839B-(E-Mail Removed)...
> > Additional info: I have already created an SQL database with all the table
> > I
> > need, I just cannot connect to it from within Access.
> >
> > Stephen
> >
> >
> > "Stephen Raftery" wrote:
> >
> > > Can any of you guys help?
> > > I am new to using SQL Server. I have a database that I wish to upsize
> > > from
> > > Access to put the back end on a server, and use Access as a front-end.
> > > However, I am stuck at the very first stage - I cannot link Access to
> > > the
> > > SQL server.
> > >
> > > I am using SQL Server Management Studio on a single computer for
> > > development
> > > purposes, no network involved yet.
> > > In Access 2010 beta, when I try External Data / ODBC / Link, then I am
> > > presented with the Select Data Source dialog. I click on New at the DSN
> > > Name
> > > field, and select SQL Server, then type in a name fro the new data
> > > source,
> > > and Finish. I then get another dialog 'Create a New Data Source to SQL
> > > Server', where I type in a description and select (local) for the server
> > > to
> > > connect to, and choose Windows authentication. This is where my problem
> > > arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17,
> > > SQL
> > > Serverdoes not exist or access denied'
> > >
> > > I am sure this is a pretty basic problem - can anyone tell me where I
> > > need
> > > to turn next?
> > >
> > > Stephen
> > >

Yep... now we are getting somewhere... if that is the name of your database.
Also sounds like you don't have SQL Server installed. What version did you
install? Did you download or use CD's?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

<Stephen> wrote in message
news:E0932345-4DFC-46C5-8EA0-(E-Mail Removed)...
Ah, I get you.
When I click on the database file, I get the message
'Windows cannot open the file 'Rotamaster.sdf'
To open it, Windows needs to know the program you want to use to open it.
What do you want to do:
@ Use the Web Service to find the corre nt program
@Select a program from a list of installed programs.


Does this shed some light?

Stephen


"Gina Whipp" wrote:

> Stephen,
>
> Before we get to the permissions issue (and the answer to the the question
> will answer the permissions issue)... Opening SQL Server Management
> Studio
> does not mean the database is *running*. Please go to the the Database
> folder and navigate to your database and double click... what happens?
> AND
> when you open SSMS do you get a prompt to log on?
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> <Stephen> wrote in message
> news:64E86A8B-8BBB-4A0B-B286-(E-Mail Removed)...
> I have tried linking while the SQL Studio is open: no joy there.
> I cannot find any option to alter Permissions: where would that be?
>
> Stephen
>
>
> "Gina Whipp" wrote:
>
> > Stephen,
> >
> > In addition to Jeff's reply... the Server also has to be running when
> > you
> > try to connect to it.
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" -
> > Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > <Stephen> wrote in message
> > news:1ED9008F-A3B2-4633-839B-(E-Mail Removed)...
> > Additional info: I have already created an SQL database with all the
> > table
> > I
> > need, I just cannot connect to it from within Access.
> >
> > Stephen
> >
> >
> > "Stephen Raftery" wrote:
> >
> > > Can any of you guys help?
> > > I am new to using SQL Server. I have a database that I wish to upsize
> > > from
> > > Access to put the back end on a server, and use Access as a front-end.
> > > However, I am stuck at the very first stage - I cannot link Access to
> > > the
> > > SQL server.
> > >
> > > I am using SQL Server Management Studio on a single computer for
> > > development
> > > purposes, no network involved yet.
> > > In Access 2010 beta, when I try External Data / ODBC / Link, then I am
> > > presented with the Select Data Source dialog. I click on New at the
> > > DSN
> > > Name
> > > field, and select SQL Server, then type in a name fro the new data
> > > source,
> > > and Finish. I then get another dialog 'Create a New Data Source to SQL
> > > Server', where I type in a description and select (local) for the
> > > server
> > > to
> > > connect to, and choose Windows authentication. This is where my
> > > problem
> > > arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17,
> > > SQL
> > > Serverdoes not exist or access denied'
> > >
> > > I am sure this is a pretty basic problem - can anyone tell me where I
> > > need
> > > to turn next?
> > >
> > > Stephen
> > >

Right, I am with you now.
I downloaded SQL Server Management Studio along with Configuration Tools and
Integration Services. I assumed that that was what I needed. Is there
something else? I obtained them from the SQL Express website.

Stephen


"Gina Whipp" wrote:

> Yep... now we are getting somewhere... if that is the name of your database.
> Also sounds like you don't have SQL Server installed. What version did you
> install? Did you download or use CD's?
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> <Stephen> wrote in message
> news:E0932345-4DFC-46C5-8EA0-(E-Mail Removed)...
> Ah, I get you.
> When I click on the database file, I get the message
> 'Windows cannot open the file 'Rotamaster.sdf'
> To open it, Windows needs to know the program you want to use to open it.
> What do you want to do:
> @ Use the Web Service to find the corre nt program
> @Select a program from a list of installed programs.
>
>
> Does this shed some light?
>
> Stephen
>
>
> "Gina Whipp" wrote:
>
> > Stephen,
> >
> > Before we get to the permissions issue (and the answer to the the question
> > will answer the permissions issue)... Opening SQL Server Management
> > Studio
> > does not mean the database is *running*. Please go to the the Database
> > folder and navigate to your database and double click... what happens?
> > AND
> > when you open SSMS do you get a prompt to log on?
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" - Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > <Stephen> wrote in message
> > news:64E86A8B-8BBB-4A0B-B286-(E-Mail Removed)...
> > I have tried linking while the SQL Studio is open: no joy there.
> > I cannot find any option to alter Permissions: where would that be?
> >
> > Stephen
> >
> >
> > "Gina Whipp" wrote:
> >
> > > Stephen,
> > >
> > > In addition to Jeff's reply... the Server also has to be running when
> > > you
> > > try to connect to it.
> > >
> > > --
> > > Gina Whipp
> > > 2010 Microsoft MVP (Access)
> > >
> > > "I feel I have been denied critical, need to know, information!" -
> > > Tremors
> > > II
> > >
> > > http://www.regina-whipp.com/index_files/TipList.htm
> > >
> > > <Stephen> wrote in message
> > > news:1ED9008F-A3B2-4633-839B-(E-Mail Removed)...
> > > Additional info: I have already created an SQL database with all the
> > > table
> > > I
> > > need, I just cannot connect to it from within Access.
> > >
> > > Stephen
> > >
> > >
> > > "Stephen Raftery" wrote:
> > >
> > > > Can any of you guys help?
> > > > I am new to using SQL Server. I have a database that I wish to upsize
> > > > from
> > > > Access to put the back end on a server, and use Access as a front-end.
> > > > However, I am stuck at the very first stage - I cannot link Access to
> > > > the
> > > > SQL server.
> > > >
> > > > I am using SQL Server Management Studio on a single computer for
> > > > development
> > > > purposes, no network involved yet.
> > > > In Access 2010 beta, when I try External Data / ODBC / Link, then I am
> > > > presented with the Select Data Source dialog. I click on New at the
> > > > DSN
> > > > Name
> > > > field, and select SQL Server, then type in a name fro the new data
> > > > source,
> > > > and Finish. I then get another dialog 'Create a New Data Source to SQL
> > > > Server', where I type in a description and select (local) for the
> > > > server
> > > > to
> > > > connect to, and choose Windows authentication. This is where my
> > > > problem
> > > > arises: I get 'Connection Failed: SQLState 08001, SQL Server Error 17,
> > > > SQL
> > > > Serverdoes not exist or access denied'
> > > >
> > > > I am sure this is a pretty basic problem - can anyone tell me where I
> > > > need
> > > > to turn next?
> > > >
> > > > Stephen
> > > >