|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Help needed with KERBROS and Native XML Web Services Posted by Al at 10/29/2007 10:36:01 AM Trying to get Native XML Web Services setup in our test enviroment, and I've
hit a problem.
When the HTTP EndPoint is set to use Integrated Authentication, I can browse
to the endpoint (using IE7 from a seperate PC) and get the WSDL back, but
when I switch the EndPoint to use KERBEROS authent...more >>
SQL Server Management Studio don't see local SQL Server 2005 Devel Posted by Mrgud at 10/29/2007 4:59:00 AM SQL Server Management Studio don't see local SQL Server 2005 Developer
Edition x64 on Vista Ultimate x64
Hi,
I have strange problem with SQL Server Management Studio on Vista Ultimate
x64. Nothing change after installing all newest service packs or hot fixes.
I have two running SQL server...more >>
SQL 2000 on SBServer 2003 Posted by mikev at 10/27/2007 1:29:01 PM I restored a database to a new server. On the new server I can access the
database. When I go to a workstation I receive the error "user name does not
exist" any help is greatly appreciated....more >>
accessing remote database Posted by Andy at 10/25/2007 7:48:17 PM Hi,
What is the best approach for a application havily using remote database to
connect to?
Somebody suggested Web service, but isn't that slow and to big overhead for
such application?
...more >>
Cannot start Replication - "Remote Desktop Connection" or TCP/IP Posted by voidptr78 at 10/25/2007 12:13:00 AM Hi,
I've got two servers to be a subscriber and publisher resp. The server
machines are in a secured environ. and I usually use my own laptop with SQL
Server 2005 on XP SP2 to connect to these machines either through Man. Studio
over TCP/IP or sometimes I connect using mstsc (remote desktop c...more >>
Query Oracle database without linked server Posted by YuS.Mei NO[at]SPAM gmail.com at 10/25/2007 12:00:00 AM I have to query Oracle database from SQL server 2000. But I do not
want to create linked server in SQL server 2000. I tried the
opendatasource as following.
SELECT * FROM OPENDATASOURCE( 'MSDAORA.1',
'Data Source=ORA;User
ID=username;Password=password' )..Clarity.GOAL_TYPE
I got error on t...more >>
MS SQL Read-Only? Posted by Tony at 10/22/2007 3:29:40 PM With either MS SQL 2000 or MS SQL 2005, how can I set up a username/password that has
READ ONLY access?
...more >>
who uses port 1709 Posted by ktmd at 10/16/2007 5:38:01 PM Hello,
I set up a new SQL 2005 SP1 server. Everything was fine for 2 weeks.
Suddently I got error "cannot generate SSPI context" when connecting to it
from a client PC, as shown below. When I use setspn to check the server I
see the line with port 1709. I check netstat -an and found no ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Enterprise Manager job setup help Posted by cmap NO[at]SPAM another.com at 10/15/2007 5:26:59 AM hi
I'm trying to get a job to run on a particular database - how do I
select the database to go with the rest of the syntax I need ?
Thanks
Elaine
...more >>
please help me Posted by yasmine at 10/10/2007 6:20:00 PM
Cannot connect to YASMINE-\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error
occurred during the login process. (provider: Shared Memory Provider, error:
0 - No process is on the other end of the pipe.) (.Net SqlC...more >>
Error: 18456, Severity: 14, State: 16. Posted by payyans at 10/10/2007 11:08:01 AM Our java web application is running into a login failure issue as shown below
after a few hours of its run.
Login failed for user '<user name>'. [CLIENT: <IP Address>]
Please note that application makes several connections to database for its
processing purpose.
We are using SQL Server 200...more >>
Cannot bind to port 1433 Posted by JR at 10/10/2007 8:05:02 AM I have an instance of SQL Server that gets recycled every night (SQL 2000
sp4, windows 2000 sp4). Every couple of weeks or so users can't connect in
the morning, and I see in the SQL log the error message 'SuperSocket Info:
Bind failed on TCP port 1433.' When I restart the SQL service, it se...more >>
Is there a reliable way to do this? Posted by Elizabeth Connolly at 10/9/2007 4:05:13 PM What is a reliable way to check to ensure that all system DBs are started
when SQL Server (SQL Express) starts up?
I am using SQL Express 2005 for a desktop application in which the user
requires the application be started at windows log-in time (so that nothing
is ever visible on the deskt...more >>
Integrated Security (SSIS) and connection pooling Posted by Paul_A at 10/9/2007 12:01:03 PM Does anyone know if transaction pooling works with integrated security? I
believe i read that the transaction is only re-usable within the same context.
...more >>
Linked DB2/400 Posted by Todd Heiks at 10/9/2007 9:57:01 AM Is it possible to write a trigger from an MS SQL 2005 table to a linked
DB2/400 table?
-Todd
...more >>
Linked Server not logging in Posted by Randy Galliano at 10/8/2007 4:32:04 PM Hello,
I a fairly complicated situation to explain in a newsgroup, but I am going
to give it a try:
1. I have an SQL 2005 server (call it Server A) with a database. In the
database is a view pointing that queries a table pointing to a linked
server, Server B (#2 below). The permissions are...more >>
SQL Server Connection Error Posted by Phil Dodgson at 10/8/2007 8:52:02 AM Hi,
I have just installed SQL Server 2005 and I'm having trouble setting up
logins, the scenario that I have is I have a number of .php pages on an IIS
Version 6 server and when you click a button, it creates a database
connection and inserts data into a table. I used Web as a Username and...more >>
is there a way to tell how a linked server is connecting? Posted by jaylou at 10/5/2007 1:07:03 PM Hi all,
How can I see if a linked server is connecting via name pipes or TCP?
Thanks,
Joe
...more >>
SQL Server 2000 Connection Timeout Issues Posted by Greg J. at 10/3/2007 2:55:01 PM What is the cause of SQL Server connection timeout errors? One application (a
very complex SQL Server 2005 SSIS package) reports the following error:
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80004005 Description: "Login timeout expired".
An OLE DB re...more >>
How many periods are REALLY needed? Posted by greenmtnsun at 10/2/2007 1:24:01 PM I have a very strange situation. A select statement I am running isn't
returning the right number of records from a linked server.
The linked server is to an Access 2000 Database using the Microsoft Jet 4.0
OLE DB Provider driver. (4.0.9505.0)
Here is the problem:
SELECT * FROM PCCHARG...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |