Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!


Archived Months
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
August 2008
all groups > sql server connect > recent posts

RE: Ansi_nulls & warnings
Posted by sksisme at 9/9/2009 6:54:14 PM
Thank you Sue this is exactly what I needed. Worked perfectly for my solution. sks From http://www.developmentnow.com/g/100_2003_8_0_0_388603/Ansi-nulls-warnings.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>


RE: Sql server 2005 Endpoints? An error ('0x80070005') occurred while attempting to register the endpoint
Posted by shijo baby at 7/16/2009 9:12:58 AM
Hi Pls try this also http://sqlservererror-info.blogspot.com/2009/07/error-has-occurred-while-establishing.html From http://www.developmentnow.com/g/100_2006_3_0_0_720863/Sql-server-2005-Endpoints-An-error-0x80070005-occurred-while-attempting-to-register-the-endpoint.htm Posted via Develop...more >>

about connecting to Oracle on a 64 bit machine with 64 bit oracle data access provider
Posted by Tina singh at 5/29/2009 6:45:41 AM
about connecting to Oracle on a 64 bit machine with 64 bit oracle data access provider in vb6 From http://www.developmentnow.com/g/100_2007_4_0_0_0/sqlserver-connect.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Cannot Open SQL Server
Posted by Robert Mijango at 4/13/2009 11:31:51 AM
I get the same error message with Crystal 8.5. I have un/re-installed SQLServer and Crystal. I have are dropped/created a new ODBC DSN. I am using SQL Server 2000.81.9030.04 SQLSRV32.DLL 08/06/2002 Any other suggestions? From http://www.developmentnow.com/g/100_2003_12_0_0_389396/Cannot-Op...more >>

RE: Cannot Open SQL Server
Posted by JN at 3/6/2009 3:17:11 AM
Hi, I get this error while I try to connect to sql server from cystal report 7. ODBC connection test was successful. So any more suggestions? From http://www.developmentnow.com/g/100_2003_12_0_0_389396/Cannot-Open-SQL-Server.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

query very very slow ...
Posted by luca at 1/15/2009 1:14:41 PM
I'm using this query via e vb ado. note: -all fields concerned in inner join are indexed. -only that when launching the command via vb code to the query is slow (perhaps 3 or 5 minutes )!!!!!!! -if the launch itself on query sql in Sql Server Mangement Express runs in 1 or 2 seconds !!!!!!...more >>

RE: hh
Posted by ljl at 8/22/2008 12:22:32 AM
hgh From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=100&threadid=1060525 Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

hh
Posted by fdsgfd at 8/22/2008 12:20:39 AM
gfjghjgh From http://www.developmentnow.com/g/100_2003_9_8_0_0/sql-server-connect.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>



Installation related
Posted by Suraj at 8/20/2008 5:26:29 AM
I have SQL Server 2000 installed my system and have all the business objects. The database objects are accessed by two different business applications. My objective is to uninstall the set up from existing location (C drive) to a new location, say D drive. My questions: 1) When I install it to a ...more >>

a question about unable to connect to local sql server
Posted by anna at 8/19/2008 11:16:23 PM
this is an error that i recieve when i want to creat an sql database in c# environment at visual studio 2005: an error has occured with establishing a connection to the server .when connecting to sql server 2005,this failure may be caused by the fact that under the default setting sql does not allo...more >>

Re: What is the default server name of SQL Server 2005 Enterprise?
Posted by Elliot at 11/2/2007 1:15:01 PM
It is useful. Thank you. "Razvan Socol" <rsocol@gmail.com> wrote in message news:#JJ6SeIHIHA.4296@TK2MSFTNGP04.phx.gbl... > If you forgot the instance name, you can use SQL Server Configuration > Manager, or look in the registry in > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Ser...more >>

Re: Permission denied in ASP.NET 2.0 with IE
Posted by William Vaughn at 11/2/2007 11:26:17 AM
I would change tactics here. I would stop using AttachDbFilename. To do so you simply need to run a one-time script to attach the database to master. After that, the database remain in place indefinitely . In any case you need to set the initial catalog in the ConnectionString. See Chapter 9 o...more >>

Re: msmq to sql?
Posted by William Vaughn at 11/2/2007 11:20:50 AM
Andy, I suggest taking the secure road here. Yes, the connection string is a key to SQL Server content--it can unlock the door to the entire server and all of its data or to a single closet that contains just the data your application needs. I suggest the latter as a security strategy. Th...more >>

Re: msmq to sql?
Posted by Andrew J. Kelly at 11/2/2007 9:10:16 AM
Now we didn't really recommend anything since we don't know your actual requirements. Why not use Windows authentication and you don't have to worry about showing any sensitive data. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Andy" <kc2ine@yahoo.com> wrote in message news:...more >>

Re: SQL Server Management Studio don't see local SQL Server 2005 D
Posted by weilu NO[at]SPAM online.microsoft.com at 11/2/2007 8:25:07 AM
Hello Mrgud, Could you please let me know the detailed steps you get this window? Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn...more >>

Tracing SQL Server 2000 Connections
Posted by Dougie Brown at 11/2/2007 7:44:04 AM
Hi We're experiencing connection timeouts when the C drive of our SQL Server is backed up to tape. Backup Exec and native Windows Backup have both highlighted/caused the connection timeouts which last for around 90 seconds at the end of the backup. It would appear that by excluding Syste...more >>

Permission denied in ASP.NET 2.0 with IE
Posted by Helmut Guenther at 11/2/2007 1:31:56 AM
When I start my ASP.NET 2.0 Website in VS2005 with XPSP2 I can connect to the SQL-Express Database without problems But when I start my Website with Internet Explorer I get the following error: CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named databa...more >>

Re: msmq to sql?
Posted by Andy at 11/2/2007 12:36:49 AM
that's what I thought. I guess I'm going to recommend what you guys suggested: Straight ADO db connection with SQL Srever mirroring. But what to hec to do with that connections string... is there any way to secure it enough whitin the application on user machine to convince them? Or maybe re...more >>

Re: msmq to sql?
Posted by Andrew J. Kelly at 11/1/2007 11:58:33 PM
> All these for 1) asynchronous access and 2) for security. Well that depends on what you are doing. Asynchronous access to a database is not very useful for most user applications. If you are only talking about SQL Server as a back end to an app that just needs to load data such as a logg...more >>

Re: msmq to sql?
Posted by Andy at 11/1/2007 7:55:27 PM
I have 2005 version. I was thinking about mirroring also, but management wants to have some kind of user separation from SQL server like web service (I don't want to do this) or messaging services like MSMQ or SQL 2005 server Broker Agent. All these for 1) asynchronous access and 2) for sec...more >>

Re: msmq to sql?
Posted by William Vaughn at 11/1/2007 10:35:20 AM
We had this problem a couple of times a day when I worked at Microsoft University. Our registration SQL Server was on campus (about 10 miles away)--accessed over a connection via dialup modems. When someone drove through the parking garage under the building, the antennas hitting the raised ...more >>

Re: msmq to sql?
Posted by Ayad Shammout at 11/1/2007 9:13:57 AM
What version of SQL do you have? Did you consider Clustering and/or DB Mirroring (in SQL 2005)? Ayad Shammout "Andy" <kc2ine@yahoo.com> wrote in message news:u%23%23CdMEHIHA.1316@TK2MSFTNGP02.phx.gbl... > Hi, > If I'd like to ensure that in case sql server is down user still can > ac...more >>

Re: What is the default server name of SQL Server 2005 Enterprise?
Posted by Andrew J. Kelly at 11/1/2007 8:32:43 AM
If it is a Default Instance the name is the same as the server it is installed on. If it is a Named Instance it is the Server Name \What ever you give it when you install it. There is no default, you must fill in the blank. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Elliot...more >>

Re: What is the default server name of SQL Server 2005 Enterprise?
Posted by Razvan Socol at 11/1/2007 6:03:17 AM
If you forgot the instance name, you can use SQL Server Configuration Manager, or look in the registry in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL. -- Razvan Socol SQL Server MVP...more >>

Re: What is the default server name of SQL Server 2005 Enterprise?
Posted by Elliot at 11/1/2007 5:52:00 AM
How if I have forgot it? "Andrew J. Kelly" wrote: > If it is a Default Instance the name is the same as the server it is > installed on. If it is a Named Instance it is the Server Name \What ever you > give it when you install it. There is no default, you must fill in the > blank. > >...more >>

msmq to sql?
Posted by Andy at 11/1/2007 12:53:12 AM
Hi, If I'd like to ensure that in case sql server is down user still can access and write the the data what option do I have? Since writing is more important I thought about MSMQ tu put between the server and the application, but what about reading? Any other techiniques? In case of MSMQ, ...more >>

Re: accessing remote database
Posted by Andy at 11/1/2007 12:47:36 AM
thanks for input. "William Vaughn" <billvaNoSPAM@betav.com> wrote in message news:ewX0kClGIHA.2100@TK2MSFTNGP03.phx.gbl... >I don't put "user" credentials in the connection string--just those >assigned to the application. The DBA then grants rights to a selected few >stored procedures or v...more >>

What is the default server name of SQL Server 2005 Enterprise?
Posted by Elliot at 11/1/2007 12:00:00 AM
How can I know? I just know computername\sqlexpress for 2005 Express. Is it possible to change the server name? Thanks for answering. ...more >>

Re: msmq to sql?
Posted by Andrew J. Kelly at 11/1/2007 12:00:00 AM
What happens then when the server that is running msmq goes down? Why would you think that would be more reliable than SQL Server? MSMQ can't even begin to duplicate the functionality of SQL Server and should never be thought of as a backup to or replacement for it. You are better off looki...more >>

RE: Help needed with KERBROS and Native XML Web Services
Posted by Al at 10/31/2007 9:53:12 AM
Hi The HTTP EndPoint has been created with WSDL = STANDARD (i.e. WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]'). "John Bell" wrote: > Hi > > Does this mean you are using custom WDSL, does default change the behavior? > > John > > "Al" wrote: > > > Hi Jo...more >>


DevelopmentNow Blog