i got an err msg

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

-

so what i should do?

to mach for a biginer,

where is this file

thanks

i did add this to the web config file

<configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>

but its wouldnt halps

|||

also tried to add

configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>
>
to
\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG
machine.config
but it wouldn't help.

well i hope you don't think i not to mach of a beginner for you guys

|||Hi,

I am not quite sure where you actually get the error message, you just posted the error message and we don′t know in which context this relates to SQL Server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

sql

I changed my windows password and now I cannot connect to SQL Server on my development mac

I changed the login password on my computer today, and now I cannot connect to the SQL Server instance I have on that same machine. I am using Windows Authentication.

I would think that, if I can log on to my computer, I would be able to connect to the database, since I have been "authenticated" by windows but, that does not appear to be the case.

Can anyone offer any advice?

Thanks in advance for any help you can provide.

When i doubt, restart

|||

I figured it out.

If anyone is interested...

I had to manually go to Administrative Tools > Services and choose (double-click) SQL Server (MSSQLSERVER). Then go to the Log On tab and change the password there. I did the same for SQL Server Agent (MSSQLSERVER). I haven't done any of the other SQL Server - related services on my machine. I will do those as needed, I guess, cause I am not using them yet.

I hope this helps someone.

|||

Ah, you're using your Windows login to run the SQL Server service. Generally not a good idea on a server, for the reason you found, but it is probably okay on a development machine.

Glad you figured it out!

Don

|||

Ahh...Thats the start up account. So your SQL Server is set up to start as a "Local Account". Generally its a good practice to use a Windows account that is not part of windows admnistrator group. Check out books on line for more info about SQL Server agent and the security model.

sql

I Changed My Servername Help Please

Hi,
I have Joined my SQL Server into another domain and had to rename the
machine as well I am running SQL Server 2000 on a Windows 2000 server on an
NT Domain
Since this I seem to have some problems with replication etc. is there a
registry setting or something I need to change where the old machine name
might be lurking?
Or is it a case of me removing then re-installing SQL Server ?
Thanks in advance for any help provided on this
Joe MellonIf you re-run the Setup from the SQL Server CD, it should show you an option
to repair registry only. Try with this first, it is quick and easy process.
You don't have to reinstall SQL Server. Maybe after the registry rebuild you
will have only to reestablish the replication.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Joe Mellon" <joe@.bluesteel.co.uk> wrote in message
news:O9vZofNsDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have Joined my SQL Server into another domain and had to rename the
> machine as well I am running SQL Server 2000 on a Windows 2000 server on
an
> NT Domain
> Since this I seem to have some problems with replication etc. is there a
> registry setting or something I need to change where the old machine name
> might be lurking?
> Or is it a case of me removing then re-installing SQL Server ?
> Thanks in advance for any help provided on this
>
> Joe Mellon
>

I cant Install SQL Server 2005 (final release) in the same machine with SQL Server Express Editi

Hi

I have download SQL Server 2005 evaluation 180 Days from Microsoft web site and install it fine without any problem in my machine

But when I try to install SQL Server Express edition on the same machine I lose many of start menu tools related to SQL Server 2005 Like.

Analysis Services -> Deployment Wizard

(All) Documentation and Tutorials

Performance Tools -> Database Engine Tuning Advisor

SQL Server Profiler

SQL Server Business Intelligence Development Studio

SQL Server Management Studio

Why all that tools removed when I install SQL Server Express Edition .

And thanks with my regarding

Fraas

Hi Fraas,
SQL Server Express does not include the features you listed and so they are not available once you move away from the Trial edition.
Regards,

Mike Wachal

SQL Express team|||thanks for your reply

but how can I install SQL Server 2005 and SQL Server Express Edition on the same machine ?

thanks with my regarding
Fraas|||

In another word how can I install SQL Server 2005 and SQL Server Express Edition in the same machine ?

|||When you install SQL Server Express Edition only select to install the database engine - do not select to install the client components. If you have another edition installed which includes client components you already have everything that's included in the Express client component installation.

Dan
http://blogs.msdn.com/dtjones

I cant Install SQL Server 2005 (final release) in the same machine with SQL Server Express E

Hi

I have download SQL Server 2005 evaluation 180 Days from Microsoft web site and install it fine without any problem in my machine

But when I try to install SQL Server Express edition on the same machine I lose many of start menu tools related to SQL Server 2005 Like.

Analysis Services -> Deployment Wizard

(All) Documentation and Tutorials

Performance Tools -> Database Engine Tuning Advisor

SQL Server Profiler

SQL Server Business Intelligence Development Studio

SQL Server Management Studio

Why all that tools removed when I install SQL Server Express Edition .

And thanks with my regarding

Fraas

Hi Fraas,
SQL Server Express does not include the features you listed and so they are not available once you move away from the Trial edition.
Regards,

Mike Wachal

SQL Express team|||thanks for your reply

but how can I install SQL Server 2005 and SQL Server Express Edition on the same machine ?

thanks with my regarding
Fraas|||

In another word how can I install SQL Server 2005 and SQL Server Express Edition in the same machine ?

|||When you install SQL Server Express Edition only select to install the database engine - do not select to install the client components. If you have another edition installed which includes client components you already have everything that's included in the Express client component installation.

Dan
http://blogs.msdn.com/dtjonessql

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

sql

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

I can't add a new Reporting Services server registration of a remote server.

I need a help.

This is the scenario:
I have installed on my machine SQLServer 2005 Developer but not reporting services because I don't have IIS.

Now there is server: W2003 + SQL Server 2005 Developer (Complete) + II6.

From the SQL Server Management Studio I can connect to the DatabaseEngine on the server but I cannot connect to Reporting Services or Integrated Services.

On particularly when I try to create a new Server Registration and I "Browse" for a server I can see only the local server!!!

Is this a systemistic, configuration issue? Some advice to solve it?

Thank you in advance.
Marina B.

So you have Win2k3 + SQL 2005 Dev edition (SQL engine & RS) + IIS6, correct? Is RS and SQL installed on the same machine? I am still not very clear about your issue. How did you try to connect and what was the error?|||

Hi,
thank you for the answer.

Yes RS and SQL are installed on the same machine (I mean the brand new W2003 server)...

At the end I was able to solve the problem enabling the SQL server Agent and Browser!!

Thank you

Marina B.

sql

I can't access cubes from excel

I try to register the dll in a remote machine but I couldn't.
Do I need to install something else in the remote machine?whats the message / error u r gett5ing. what exactly have u done?"|||The error is Load Library "C:\........................." failed
GetLastError returns 0x00000485
In the client I haven't installed anything. I only copied the dll and try to register it. Should I install something else?
Thanks in advance|||Does anyone has connected with Excel from other computer than the server?
From the server I can connect.
What whould I install in the computer to connect to the server with Excel?
Thanks in advance.|||

Before you can connect from Excel to the Olap 2005 server, you need to install Microsoft OLEDB for Olap 9.0.

The file you need to install is: pts9.msi - Located in
"En_SQL_DEV_x86_ctp_JUNE2005\Redist\Analysis Services\pts9.msi".

Best regards,

Jakobsgaard

|||Yes I have tried this with no luck.
I think is a version problem, my server is April CTP.
I'll try to install client tools in remote client.sql

I cannot log in with sa user (error 18452)

Hi to all.

I'm trying to log in on local machine to my SQL Server 2005 (in Windows Server 2003) using a user not trused, like as 'sa' user, but I receive the error Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452).

No problem to connect with trusted user (my logon user to operating system).

I set the auth mode to SQL Server & Windows but doesn't work.

What can I do?

Ciao.

Hi,

you did either not set Mixed Authentication for the instance you are connecting, or you are connecting to the wrong instance or you did not restart the service after changing the authentication mode. The is no other explanation for this error message.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I've seen people get this error when trying to work out what authentication mode they want. They switch from one to the other, but don't restart the service - only to find that the mode hasn't actually changed yet.

Rob

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

I can not start (initialise) report server status from reporting services configuration ma

I have reporting services installed on my machine and just a couple of days back every thing was working correctly until some thing i have no idea of happened and screwed up every thing. No i can not access report manager and report sever. When i open reporting services configuration manager, the server status is not initialised and results in following error in the computers event log.

Service cannot be started. System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)

File name: 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' --> System.Runtime.InteropServices.COMException (0x800736B1): This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)

at Microsoft.ReportingServices.Library.ServiceAppDomainController..ctor()

at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

Accessing report manager from the browser also throws this exception.

Server Error in '/ReportServer$SQLExpress' Application.

---

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer' because access is denied.

Source Error:

[No relevant source lines]

Source File:c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\web.config Line:0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

I'm having the same problem and I was just wondering if you managed to get your report server working

|||

Okay so I got it working.

I got this solution fromAaron Stebner's blog.

Create a batch file with the following commands:

cd %SYSTEMROOT%\WinSXS
for /D %%i in (*vc80*) do rd %%i /s /q
del manifests\*vc80* /q
cd policies
for /D %%i in (*vc80*) do del %%i\* /q

Run the batch file

Then run a repair install of SQL reporting services.

And it should come back.

|||

On my side, i got it working by just un-installing and then re-installing reporting services.

I am trying to install and config MySQL ... if there is a FAQ I will read ...

Hello,

My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.

1) When I run the Config Wizard, I get the following message:

"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?

2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @.pkgdatadir@. or inside C:/Program."

Suggestions please.

Kind regards, Vasya"Vasya" <vigalchin@.gmail.comwrote in message
news:1193890280.276080.101840@.d55g2000hsg.googlegr oups.com...

Quote:

Originally Posted by

Hello,

There probably is a FAQ, but this newsgroup is dedicated to Microsoft SQL
Server, so any help here will be limited.

(though I'll recommend looking at SQL Server Express 2005).

Quote:

Originally Posted by

>
My goal is to setup and configure the "Community MySQL server" on
my "Vista" laptop. I want to run the server and clients on the same
"machine" using the "loopback" IP addr (127.0.0.1) to talk between
MySQL clients and the MySQL server.
>
1) When I run the Config Wizard, I get the following message:
>
"The security settings could not be applied. Error number 2003.
Can't connect to the MySQL server". I checked via the Vista Task
Manager and there was a MySQL server instance running. I am probably
more of a POSIX API programmer .. in any case I remember that on
Windows 2000 that there was some kind of "system log" .. can't find it
on Vista(through the Control Panel) to get a better error message. Can
somebody point to the "system log" or help me with the error message?

Yes, there is an event log. I don't have Vista so not sure if they've moved
it but on XP you can go to My Computer, right click, click on MANAGE and
drill down from there.

Quote:

Originally Posted by

>
>
2) I finally tried to run the "mysql_install_db" script to
"instantiate" a MySQL database instance. I ran this script from a
"http://www.cygwin.com" shell because the script is a Unix script. I
got the error: "FATAL ERROR: Could not find SQL file '/
mysql_system_tables.sql' in @.pkgdatadir@. or inside C:/Program."

Search and replace / with \ ?

Quote:

Originally Posted by

>
Suggestions please.
>
Kind regards, Vasya
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

I am not able to view RS folders and reports.

I created reports and deployed but i am not able to see on IE my RS folders
I used this path and also i used instead of localhost i used my machine name;
http://localhost/reports$SQL2005/Pages/Folder.aspx
I checked IIS and RS, it's running.
Also i stoped and start again.
It still not working.
What else should i do?
But it did work couple days ago.
Please help.
Thanks.On Jul 26, 11:44 am, GGill <GG...@.discussions.microsoft.com> wrote:
> I created reports and deployed but i am not able to see on IE my RS folders
> I used this path and also i used instead of localhost i used my machine name;
> http://localhost/reports$SQL2005/Pages/Folder.aspx
> I checked IIS and RS, it's running.
> Also i stoped and start again.
> It still not working.
> What else should i do?
> But it did work couple days ago.
> Please help.
> Thanks.
The only other thing I can think of are to stop and restart the SQL
Server service (sqlserver.exe) and the RPC service (remote procedure
call). If this doesn't work, you may need to reinstall SSRS. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant

I am not able to connect to SqlServer 2005

Hi All,

I am trying to connect to SqlServer 2005 whihc is running on another machine. But it is giving error. ie.

"

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

"

this si my connection string information

//SqlConnection cn = new SqlConnection("Server=id03;uid=sa;pwd=infokall;database=TestDB");

SqlConnection cn = new SqlConnection(conn);

SqlCommand cmd = new SqlCommand();

string Value;

string query = sqlInfo.SQL;

cmd.CommandType = CommandType.Text;

cmd.Connection = cn;

cmd.CommandText = query;

if (Convert.ToInt32(cn.State) == 0)

cn.Open();

Value = cmd.ExecuteNonQuery().ToString();

// return Value;

Response.Write(Value);

plz help me out.

Regards

Raju

Have a look at the Screencast "Enable Remote Connections" on my site under the section Screencast > Enable Remote Connections

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

(Great screencast Jens)

Raju,

Another things to keep in mind that this error may also be the result of a firewall blocking traffic. Please see the BOL for instructions on configuring the Windows firewall (http://msdn2.microsoft.com/en-us/library/ms175043.aspx).

Il-Sung.

I am getting this err msg when trying to logon to my website on the web

HelloI am getting this err msg when trying to logon to my website on the web - on my machine there is no prob, An error occurred while established a connection to the server.
When connection to Sql.S 2005, this failure may be caused by the fact that
under the default settings sql.s doesn't allow remote connection.
(provider :Sql.S Network interface, error:26- Error Location Server/Interface Specified)(the files path is like in the web host s)

You need to configure the SQL 2005 database for the membership schema. Google aspnet_regsql.exe for help on it.

Jeff

|||

Could you check this link to see whether this is the issue?

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Hyperthreading and Licensing

I like to know how many licenses are needed for a single processor machine
that has hyperthreading on and shows 2 CPU.You only need to license the physical processors :-
www.microsoft.com/sql/howtobuy/SQLonHTT.doc
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:7FACC10E-BD3E-4F75-B0FD-7B99973512AD@.microsoft.com...
>I like to know how many licenses are needed for a single processor machine
> that has hyperthreading on and shows 2 CPU.|||Assuming you use per processor licecing:
On license per physical processor that the OS can utilize.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:7FACC10E-BD3E-4F75-B0FD-7B99973512AD@.microsoft.com...
> I like to know how many licenses are needed for a single processor machine
> that has hyperthreading on and shows 2 CPU.

Hyper Threadng with SQL 2000 ?

Is it better to enable Hyper Threading on a DB machine. I am running only SQL 2000 on my machine no other service is running. I have noticed in Task Manager that in peak time when there is some load on DB one Proccesor proccesing goes to 100 % while other reamin idle or maximum go to 20 to 30 %. I want whole peoccesing for database only.

If some one has any tips for improving database performance then please share it.mmmmmmmmm

Heres a good link to HyperThreading if anyones interested

http://www.2cpu.com/articles/42_2.html

But Beware as YOUR SERVER HARDWARE MUST SUPPORT THIS NEW Technology

and as Intel say

Performance will vary depending on the specific hardware and software you use. but could provide a performance increase in the neighborhood of 10-30%, depending on the application and the situation

If your really interested you could set up 2 test machines and try it but IMHO... I think your barking up the wrong tree as far as Twin/Quad CPU Usage balancing is concerned.

As far as tips for improving database performance try

Higher Spec Hardware & more RAM,
Transaction file physically stored on a seperate Hard Disk away from the RAID Array of the Data File,
Tune Indexes & tweak sloppy Querys etc...etc...etc...etc...etc...etc...etc...etc. ..

GW|||The most important thing I've read is to limit the max degreee of parallelism to the number of physical processors when using HT.

hyper threading

Hi,
Are there any issues/benifits when running SQL Server 2000
EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
with hyper threading enabled?
Thanks
Oskar
Oskar,
Works for me - I have some 4 way servers with hyperthreading. I've not
heard of anything that would cause any issues. Make sure you are on the
latest service packs though (looks like you are).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Oskar wrote:
> Hi,
> Are there any issues/benifits when running SQL Server 2000
> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
> with hyper threading enabled?
> --
> Thanks
> Oskar
|||At a minimum... you might consider changing max degree of parrelism to the
PHYSICAL number of processors rather than the logical. I've seen many cases
where you'll have problems with cxpacket waits if you get a 4X plan on a box
with 2 physical but 4 logical processors...
Of course this isn't always true. But something to think about...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:2df001c4a217$c7278520$a601280a@.phx.gbl...
> Hi,
> Are there any issues/benifits when running SQL Server 2000
> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
> with hyper threading enabled?
> --
> Thanks
> Oskar
|||When is it true? And when is it NOT true?
Please give us details.
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:uQi0GkjoEHA.3900@.TK2MSFTNGP10.phx.gbl...
> At a minimum... you might consider changing max degree of parrelism to
> the
> PHYSICAL number of processors rather than the logical. I've seen many
> cases
> where you'll have problems with cxpacket waits if you get a 4X plan on a
> box
> with 2 physical but 4 logical processors...
> Of course this isn't always true. But something to think about...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:2df001c4a217$c7278520$a601280a@.phx.gbl...
>
|||Have you heard that any of post SP3(a) fixes help? I can't
find a confirmation of this on MS website though.
Oskar

>--Original Message--
>Oskar,
>Works for me - I have some 4 way servers with
hyperthreading. I've not
>heard of anything that would cause any issues. Make sure
you are on the[vbcol=seagreen]
>latest service packs though (looks like you are).
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602m.html
>
>Oskar wrote:
2000[vbcol=seagreen]
CPUs
>.
>