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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

> 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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

How can I know? I just know computername\sqlexpress for 2005 Express. Is it possible to change the server name? Thanks for answering. ...more >>

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 >>

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 >>

Hello Mrgud, You may just click update the local instance in the server list to show all the installed instance on the local server. Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Gr...more >>

How can I do this in "browse for more..." window when I go to connect database engine in SSMS? Thanks... Stjepan "Wei Lu [MSFT]" wrote: > Hello Mrgud, > > You may just click update the local instance in the server list to show all > the installed instance on the local server. > >...more >>

Hi Does this mean you are using custom WDSL, does default change the behavior? John "Al" wrote: > Hi John, > > I changed the WS to return some details from sys.dm_exec_connections as > well, so I could see a little more of what was going on when calling the WS. > > When I have sp...more >>

Hi John, I changed the WS to return some details from sys.dm_exec_connections as well, so I could see a little more of what was going on when calling the WS. When I have specified NTLM as an Authentication method (position doesn't appear to make a difference), then I can get a WSDL back (w...more >>

Hi I am not sure if this is the case and can't find any documentation to say so. Have you tried AUTHENTICATION=KERBEROS,NTLM and AUTHENTICATION=NTLM, KERBEROS to see if there are any differences? John "Al" wrote: > When I do the > ALTER ENDPOINT <endpoint> AS HTTP (AUTHENTICATION=(...more >>

When I do the ALTER ENDPOINT <endpoint> AS HTTP (AUTHENTICATION=(KERBEROS)), I don't get the WSDL. But I have discovered that the endpoint still accepts and processes calls to the web services on the EndPoint. When I do ALTER ENDPOINT <endpoint> AS HTTP (AUTHENTICATION=(INTEGRATED)), I do g...more >>

Thnx! I forget this! :) Then Yes, I try it now and I can connect on both instances but still dont see any in local server tab and see only KONGORA instance in network servers tab when browsing for servers to connect... What is wrong? Any idea? :) "Razvan Socol" wrote: > The instance ...more >>

The instance called MSSQLSERVER is a default instance, not a named instance. When you connect to it, just connect to COMPUTERNAME, not to COMPUTERNAME\MSSQLSERVER (of course, replace COMPUTERNAME with your computer name). -- Razvan Socol SQL Server MVP...more >>

Hello Stjepan, I understand that you could not get the local server listed in the server lists. Could you please let me know whether you could connect to the local instance? Sincerely, Wei Lu Microsoft Online Community Support ================================================== ...more >>

Well, I can connect to local instance KONGORA that is first one installed and this one I see in network database list. On instance MSSQLSERVER I can't connect at all. Both instances are local instances and both instances I can administer in Configuration tools... "Wei Lu [MSFT]" wrote: >...more >>