Regarding domain name for mirroring

Hi guys, may I know whether the domain name needed to be same for the principal server and mirror server in order to get a connection between both the servers and setting up mirroring section successful? Is it possible to use different domain name for both servers for setting up the mirroring section. Can someone share his/her idea or experience like how to setting up the mirroring section and the configuration for the windows before setting up. Thx and hope can get any assistance here.

Best regards,

Hans

Yes, Database Miroring can be setup across two different domains.Please look at the Books Online at http://msdn2.microsoft.com/en-us/library/ms177412.aspx for details.

Reg: ADOMD Connection With multi language support

I have a SQL Server AS 2005 Database with multi language support. Through Analysis Service browser if i change the language iam getting the selected language data.

In My web application by using ADOMD I need to fetch different languages data. How can get the different languages data?

In the Sql Server Reporting Sevice also i need get the different languages data.If any body knows about this can you please help me.

Regards

Hanu

Moving the thread to the more appropriate forum.|||

Try setting the Locale Identifier connection string property to the numeric identifier of the locale whose language you want to see. For instance, if you connect to the Adventure Works cube with Locale Identifier=1036 then you'll see the French translation of the cube.

HTH,

Chris

Refuse connections

Hi guys,

I would like to know how could I configure my SQL Server (2000) to refuse every connection except localhost or server-name ?

I am sure this can be acomplished, but I've looked everywhere and can't find it.

I use asp.net only and I want to configure the server to accept connections from local computer and that's it. Any thoughts?

ThanksDisable all network protocols except shared memory.|||Thanks.

Also, I have two instances of MSSQL installed, one is SQL 2000 & other is Desktop Edition, will the client configurations apply to both or just to SQL 2000 and if just to SQL 2000 how can I configure it also for the Desktop Edition?|||It doesn't work. Tested it today, disabled all protocols except shared memory and I still can connect from another box to that specific box with Enterprise Manager (for example)

Any other ideas?|||It doesn't work. Tested it today, disabled all protocols except shared memory and I still can connect from another box to that specific box with Enterprise Manager (for example)

Any other ideas?

Did you restart SQL after changing the network configuration? Look at the error log for SQL Server when it restarts, there should be entries in there to indicate what protocols/ports SQL is listening on.

Regards,

hmscott|||Restarted, still same thing. I can connect from one box to the other. Log file:

2005-12-06 04:11:31.10 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2005-12-06 04:11:31.10 server Copyright (C) 1988-2002 Microsoft Corporation.
2005-12-06 04:11:31.10 server All rights reserved.
2005-12-06 04:11:31.10 server Server Process ID is 3336.
2005-12-06 04:11:31.10 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-12-06 04:11:31.20 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2005-12-06 04:11:32.78 server SQL Server configured for thread mode processing.
2005-12-06 04:11:32.79 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2005-12-06 04:11:32.85 server Attempting to initialize Distributed Transaction Coordinator.

2005-12-06 04:11:35.71 spid3 Starting up database 'master'.
2005-12-06 04:11:36.10 spid3 Server name is 'SERVER9'.
2005-12-06 04:11:36.10 spid3 Skipping startup of clean database id 44
2005-12-06 04:11:36.26 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-12-06 04:11:36.26 spid5 Starting up database 'model'.
2005-12-06 04:11:36.35 spid8 Starting up database 'msdb'.
2005-12-06 04:11:36.35 spid9 Starting up database 'pubs'.
2005-12-06 04:11:36.37 spid10 Starting up database 'Northwind'.
2005-12-06 04:11:36.37 spid11 Starting up database 'ahsweb'.
2005-12-06 04:11:38.68 spid5 Clearing tempdb database.
2005-12-06 04:11:39.42 server SQL server listening on 69.56.147.XXX: 1433.
2005-12-06 04:11:39.42 server SQL server listening on 69.56.147.XXX: 1433.
2005-12-06 04:11:39.42 server SQL server listening on 69.56.147.XXX: 1433.
2005-12-06 04:11:39.42 server SQL server listening on 69.56.147.XXX: 1433.
2005-12-06 04:11:39.42 server SQL server listening on 69.93.178.XXX: 2005-12-06 04:11:39.42 server SQL server listening on 69.93.178.XXX: 1433.
2005-12-06 04:11:39.42 server SQL server listening on 127.0.0.1: 1433.
2005-12-06 04:11:40.45 server SQL server listening on TCP, Named Pipes.
2005-12-06 04:11:40.48 server SQL Server is ready for client connections
2005-12-06 04:11:39.95 spid9 Starting up database 'ahl'.
2005-12-06 04:11:40.06 spid10 Starting up database 'afp'.
2005-12-06 04:11:40.31 spid8 Starting up database 'act'.
2005-12-06 04:12:19.15 spid8 Recovery is checkpointing database 'eah' (73)
2005-12-06 04:12:29.78 spid51 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
2005-12-06 04:12:55.46 spid3 Recovery complete.
2005-12-06 04:12:55.46 spid3 SQL global counter collection task is created.|||The Enterprise Manager says TCP is disabled but it still shows up on the logs

Any work arround?|||2005-12-06 05:37:02.30 server SQL server listening on 69.9.44.XXX 1433.
2005-12-06 05:37:02.30 server SQL server listening on 69.9.44.XXX: 1433.
2005-12-06 05:37:02.30 server SQL server listening on 69.9.44.XXX: 1433.
2005-12-06 05:37:02.30 server SQL server listening on 69.9.44.XXX: 1433.
2005-12-06 05:37:02.30 server SQL server listening on 69.9.44.XXX: 1433.
2005-12-06 05:37:02.30 server SQL server listening on 127.0.0.1: 1433.
2005-12-06 05:37:02.30 server SuperSocket Info: Bind failed on TCP port 1433.
2005-12-06 05:37:02.30 server SuperSocket Info: Bind failed on TCP port 1433.
2005-12-06 05:37:02.32 server SQL server listening on TCP, Shared Memory.
2005-12-06 05:37:02.32 server SQL Server is ready for client connections

Even thought TCP is disabled|||Any more thoughts? Anyone?|||You're sure you are diabling TCP in the Server Network Parameters (or Server Network Utility)? The Client network utility looks the same, but it has a different function. Also, why the multiple IP addresses? I don't usually multi-home a database server (except for a cluster), so I don't know how SQL will behave with multiple IP addresses.

Regards,

hmscott

Refresh Memory Usage History in Taskman

Hi,
After some time, my server Memory Usage History run up to 80%-90% even the
server does not have any connection in it.
This is server running only MS SQL 2000 + IIS in Win2K Server.
I was wondering that, by using the Win / WMI command to refresh / reset
this Memory Usage History.
Does anyone try this before or any ideal from you all?
Thank you.....
--
Regard,
Kzeto ngHave a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Kzeto ng" <kzetong@.yahoo.com> wrote in message news:eVe2I3kuDHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After some time, my server Memory Usage History run up to 80%-90% even the
> server does not have any connection in it.
> This is server running only MS SQL 2000 + IIS in Win2K Server.
> I was wondering that, by using the Win / WMI command to refresh / reset
> this Memory Usage History.
> Does anyone try this before or any ideal from you all?
> Thank you.....
> --
> Regard,
> Kzeto ng
>
>|||How much memory do you have, how much is assigned to SQL (see SQL
configuration parameters)?
And how much is the threshold set for IIS (check your machine.config file)?
Willy.
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:eVe2I3kuDHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After some time, my server Memory Usage History run up to 80%-90% even
the
> server does not have any connection in it.
> This is server running only MS SQL 2000 + IIS in Win2K Server.
> I was wondering that, by using the Win / WMI command to refresh / reset
> this Memory Usage History.
> Does anyone try this before or any ideal from you all?
> Thank you.....
> --
> Regard,
> Kzeto ng
>
>

Referring to Sql connection string in web.config from code behind

Every time I move my project from my computer to the testing server I have to change the connection string references in the aspx side and in my code behind.

For the code behind I declared the SqlConnection string at the top of the code-behind page for both connection strings and comment out the one not in use. Obviously I then comment out the string not in use in the WebConfig as well.

Being superlatively lazy I always look for the easiest and quickest way to do most anything - connection strings included. Having to comment out strings twice brought rise to the question of whether I can refer to the connection string in the web.config file from the code-behind page. I'm sure it can be done, and I did a good amount of hunting around, but I couldn't find any examples of code that would do that.

Currently, as I said above, I have two connection strings declared at the top of my code-behind. Here's an example of one:

Private sqlConnAs New SqlConnection("Data Source=DATABASESERVER;Initial Catalog=DATABASE;User ID=USER;Password=PASSWORD")

Then, I just use sqlConn as usual in my binding without having to "dim" it in every sub:

sdaPersonnel =New SqlDataAdapter(strSqlPersonnel, sqlConn)

Then there's the SqlConnections set up by the wizard on the aspx side:

<asp:SqlDataSource ID="sqlDataSourcePayrollCompany" Runat="Server" ConnectionString="<%$ ConnectionStrings:DATABASECONNECTIONSTRING%>" ...>

And for the connection in the web.config:

<add name="DATABASECONNECTIONSTRING" connectionString="Data Source=DATABASESERVER;Initial Catalog=DATABASE;User ID=USER;Password=PASSWORD" providerName="System.Data.SqlClient" />

So, what would be the code in the code-behind page to refer to the connection string in the web.config file?

Thanks!

To refer to the connection string via code: ConfigurationManager.ConnectionStrings["<ConnectionStringName>"]|||

Hey, Stiletto, Thanks! That did the trick (or, at least, it got me on the right track). I wasn't exaclty sure how to actually add that to my connection string code, so I had to do some hunting and trying different syntax, but ended up with this working:

Private sqlConnAs New SqlConnection(ConfigurationManager.ConnectionStrings("DATABASECONNECTIONSTRING").ConnectionString)

Thanks again!

Reduce time connection to AS2005

what is "slow"?
when the pivottable access the cube, the first time a query is executed
against the server to retrieve the measure names, but this query also ask
for the data, not only the labels. (use the profiler to see this query)
if 1 of your measures is a complex one, then you'll suffer a delay.
if your metadata is more complex in your cubes, then the time required to
retrieve the metadata is longer.
verify if you have the right SP level installed on the server AND the client
verify if you have activated the compression
also, it could be an authencation issue, maybe you suffer a delay due to a
network configuration issue (verify the DNS configuration if you use the
Active Direcotry)
again, use the profiler on the server to identify the source of the problem.
"Kazmane" <mkazmane@.capinfo.co.ma> wrote in message
news:%23y9YKXulGHA.1972@.TK2MSFTNGP05.phx.gbl...
> can someone help to reduce a time connecting to As2005 with using OLEDB9.0
> and PivotTable.
> thanks.
>can someone help to reduce a time connecting to As2005 with using OLEDB9.0
and PivotTable.
thanks.|||what is "slow"?
when the pivottable access the cube, the first time a query is executed
against the server to retrieve the measure names, but this query also ask
for the data, not only the labels. (use the profiler to see this query)
if 1 of your measures is a complex one, then you'll suffer a delay.
if your metadata is more complex in your cubes, then the time required to
retrieve the metadata is longer.
verify if you have the right SP level installed on the server AND the client
verify if you have activated the compression
also, it could be an authencation issue, maybe you suffer a delay due to a
network configuration issue (verify the DNS configuration if you use the
Active Direcotry)
again, use the profiler on the server to identify the source of the problem.
"Kazmane" <mkazmane@.capinfo.co.ma> wrote in message
news:%23y9YKXulGHA.1972@.TK2MSFTNGP05.phx.gbl...
> can someone help to reduce a time connecting to As2005 with using OLEDB9.0
> and PivotTable.
> thanks.
>