sql server clients:
Sounds like it must be a connection string issue or else you aren't
connecting using an account that has an enabled login/permissions on
the SQL Server. Can you connect to the server using other tools, like
the Query Analyzer or Enterprise Manager? Also, are you using an ADP
or MDB? If you haven't yet learned SQL Server, you should. It's not
just a bigger Jet. SQL Books Online and
www.microsoft.com/sql are a
good place to start. There are also many excellent entry-level books
out there. The learning curve is much higher than it was for Access.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446 On Fri, 26 Dec 2003 15:20:51 +0100, "PatGroup"
[quoted text, click to view] <newsgroup@click-twice.ch> wrote:
>Hi all there
>
>After installing my SQL Server 2000 on a pysical server, I wanted to test a
>first connection from my desktop pc (connected to the server), using MS
>Access 2003 as the front-end.
>
>I am not able to connect to the sql server, since I get message "access
>denied or no sql server exists".
>It is clear, that the lan connection works for all other daily operations.
>The sql server was registred correctly.
>
>I guess, that a first connection to a just created database with a little
>test-table on the sql server must be rather simple in my little lan. Can
>anybody give me a hint?
>
>
>Thank you in advance
>PatGroup
>
Hi all there
After installing my SQL Server 2000 on a pysical server, I wanted to test a
first connection from my desktop pc (connected to the server), using MS
Access 2003 as the front-end.
I am not able to connect to the sql server, since I get message "access
denied or no sql server exists".
It is clear, that the lan connection works for all other daily operations.
The sql server was registred correctly.
I guess, that a first connection to a just created database with a little
test-table on the sql server must be rather simple in my little lan. Can
anybody give me a hint?
Thank you in advance
PatGroup
