I have a serious SQL Express connection problem on one of our customers
machine. The errormessage reads: "User does not have permission to perform
this action".
Our application is a .Net 2.0 Windows Application. Using the

We are running a J2EE 1.3 application in WebSphere5 on an AIX 5.2.  The
application connects to 13 MSSQL 2000 databases running on a MS 2003 Server
that have had all critical patches applied. The JDBC driver version is
2.2.0029. Shortly after the DST patch was applied to the AIX ...

Last night we had a major storm hit us and the power went out. The SQL 2000
server has a UPS on it so should have went down gracefully - but who knows.
Anyway, this morning no one was able to get into the data. When I checked
the server, I noticed that all of our databases ...

I have a feeling this might be a security problem so I posting the question
in the security group as well.  Sorry for the double post, I'll paste any
answers over there as well.
Here's the problem;

I can create an Alias for a remote server fine using the Client Network
Utility (Alias tab, Add -> "Add Netwok Library Configuration" - TCP/IP,
Server name = IP Address, specify port number).
... how can I accomplish the same thing using TRANSACT-SQL so I can create a

Seagate crystal reports:
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL

I have two machines called MA and MB. MA is hosting IIS and MB is hosting SQL
Server. I'd like to use integrated security to access SQL Server in my
application hosted in IIS. How should I configure the SQL Server so that it
can recognize the Network Service account in another ...

I'm trying to package SQL 2005 Express SP2.
1) How do I specify which TCP/IP port to use (instead of the default of
1433)
2) How do I automatically configure the firewall for the port specified

need help about call sp sql server in vb.net
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

The following code works ...
Set objWMIService =
GetObject("winmgmts:\\.\root\Microsoft\SqlServer\ComputerManagement")
Set colItems = objWMIService.ExecQuery("SELECT * FROM

What is a best practice,
Keep connection open,
or Connect/Disconnect in each sql statement?
I´m using visual studio 2005, c#.

i have wrote a java class that retrieving stored procedure parameters
metadata, with MSSQL 2000 i can retrieve the @RETURN_VALUE parameter and
handle it well to get the value returned by the procedure, but if i try the
same code on MSSQL 2005 the parameter @RETURN_VALUE is ...

I have a routine that binds a string to a query.  It is passed a
string and a length or NULL and 0.  It works find for non-null strings
but I cant get the handling of NULL to work.
void bindString(struct _query *Q, int i, void *data, size_t len) {

Hello, I am trying to connect to a JBase database via an Attunity Connect
ODBC machine DSN but I'm struggling with the syntax. The DSN is called
ClarityODBC and this is the syntax I'm using:
SELECT *

We are bumping up against the paramter limit in an RPC request coming through
the latest version of the MS JDBC driver (to MS SQL Server SP1). Here's the
stack trace
com.microsoft.sqlserver.jdbc.SQLServerException: The incoming tabular data