First, a confession.  I posted this question earlier today in
microsoft.public.vsnet.general (which I now think was the wrong Discussion
Group).
Now, if you're willing to read further... I'm setting up a new VB.Net and

In SQL 2005 is it possible on the server to limit the number of
connections per database?

It give an error with the connection (link server created) made and the
security set to "Be made using this security context" ...
the full error is:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Nameserver"

I can connect to SQLServer using Query Analyzer and execute queries just fine
but when I try to drop down the list of databases or open the Object Browser
window it freezes. I suspect it has something to do with authentication. It
is checking to see which databases I am allowed ...

http://www.thewayithink.co.uk/post/So-youe28099ve-hard-coded-VAT-at-17525-in-SQL.aspx
The third party app developer went bust a year ago and been telling the
clients they need to move on to another app / find another sql person..
In the meantime a step by step guide how to run this ...

I have cleanly and without error, installed Visual Studio 2008 Express sp1
and SQL 2008 Express with full services etc.  Converted an Access DB with SQL
Imp/Exp tools.  I gave myself ownership of the converted file.  Changed
permissions at the file level.  But I cannot access the ...

I upgraded to a new computer, and now I can't connect to the sqlserver. I am
able to connect using "Microsoft SQL Server Management Studio Express CTP"
but I am not able to connect using ms access. I went to the old PC, and was
able to connect using access.

Good day. I am having a SQL Server connectivity issue as below: -
web.config
----------
 <connectionStrings>

Environment: Access 2003 front-end, SQL Server 2005 back-end with a named
instance.
I need to use the SQL Server driver instead of the Native Client driver when
linking the table since the former is not available in all our pc's.  On the

We have accounting system,  APS,  which is sitted in SQL2005 stnd. Last week,
because of shortage of hardware resource, we move the whole database to new
server. there is no error in the first week after migration. But later, most
of client users have been getting the error ...

I have installed SQL 2000 (again) to try and resolve the problem that SQL is
not listening on TCPIP. I need port 1433. I have checke the network
configuration, client config, registry etc.
I have done some research and in the error file

I'm having a strange problem here. I'm trying to connect to a remote SQL
Server database but I keep getting this error:
An error has occurred while establishing a connection to the server.  When
connecting to SQL Server 2005, this failure may be caused by the fact that

I have a local server (i.e. MYSERVER) and a local database (i.e. MYDATABASE)
here in our location.
I have set up a "Linked Server" entry on MYSERVER which links to the HMS
Server. I test the connection (using username and password above) and the

Our application is being developed in JBoss 4.3.0.GA_CP02 against
SQLServer 2005 and currently uses the JTDS jdbc driver without any
major problem.  We've recently been investigating changing over to the
MS JDBC driver and I've reconfigured our app to use it (Microsoft SQL

We currently are using Access 2003 and SQL Server 2000.   We plan to upgrade
our SQL Server to 2008.  Our biggest concern is the Compatibility issues with
access.  Ideally we would like to stay on Access 2003, but what little
research I have done, it does not look like Access ...