Connect SQL Server Express 2005 on a remote Computer

Hello Everyone,

I just got a Virtual Dedicated Server and installed SQL Server Express 2005 on it and while I was installing choose Mix Mode authentication and setup a sa password.....

I want to connect to that database remotely from my machine using VS 2005 or Management Studio....both are encountering the same problems.....

On the Virtual Dedicated machine if I install management studio I run has no problem....it asks me for the server name : something\SQLEXPRESS then username and password and works fine...

The same thing I try to do remotely is not happy with ....I tried to give the IP address of the server same thing no luck.....

Can somebody tell me what I'm doing wrong and where....

Thanks,

Harsimrat

Solved...

Had to do some installations again...

Thanks,

harsimrat

Conflict Viewer included with MSDE 2000 Release A?

It seems that installing MSDE 2000 Release A does not install the conflict viewer, and therefore if a subscription is set to allow interactive conflict resolution at the client, it will not work...
Does anyone have the definitive answers to the following?
- Is Conflict Viewer supposed to be included with MSDE 2000 Rel A?
- Was it included in versions of MSDE prior to Rel A (my research has indicated that it was)?
- Is Conflict Viewer redistributable (hopefully there's a merge module somewhere?!)
- Does any other MS product apart from SQL Server install the Conflict Viewer (we have observed that certain machines that don't have SQL Server installed still have the conflict viewer...)?
Just for more information, our scenario is as follows:
- SQL Server 2000 database server, set with a publication allowing anonymous pull subscriptions, and articles set up to allow interactive conflict resolution.
- MSDE 2000 Rel A clients, with anonymous pull subscriptions to the server. When an on-demand synchronisation is attempted, we get the following message - "the process failed to
get information about the interactive resolver component from the
registry".
- If the files under Program Files\Common Files\Microsoft Shared\Database Replication are manually copied across and registered, it all works.
There's other posts asking similar questions in the replication discussion group, from Tanya Milanova and markeboy, but the answers given don't answer the question about redistribution of the component...
Cheers, Jim
Conflict Viewer as well as all the other tools for setting up and
maintaining replication on SQL Server 2000 are part of Enterprise Manager
and are not (and never have been) part of the MSDE distribution. The SQL
Server 2000 client tools (EM) cannot be legally redistributed.
Jim
"Jim Kirton" <JimKirton@.discussions.microsoft.com> wrote in message
news:EC5C41EB-AACB-4642-B57B-81C343DC8DE5@.microsoft.com...
> It seems that installing MSDE 2000 Release A does not install the conflict
viewer, and therefore if a subscription is set to allow interactive conflict
resolution at the client, it will not work...
> Does anyone have the definitive answers to the following?
> - Is Conflict Viewer supposed to be included with MSDE 2000 Rel A?
> - Was it included in versions of MSDE prior to Rel A (my research has
indicated that it was)?
> - Is Conflict Viewer redistributable (hopefully there's a merge module
somewhere?!)
> - Does any other MS product apart from SQL Server install the Conflict
Viewer (we have observed that certain machines that don't have SQL Server
installed still have the conflict viewer...)?
> Just for more information, our scenario is as follows:
> - SQL Server 2000 database server, set with a publication allowing
anonymous pull subscriptions, and articles set up to allow interactive
conflict resolution.
> - MSDE 2000 Rel A clients, with anonymous pull subscriptions to the
server. When an on-demand synchronisation is attempted, we get the following
message - "the process failed to
> get information about the interactive resolver component from the
> registry".
> - If the files under Program Files\Common Files\Microsoft Shared\Database
Replication are manually copied across and registered, it all works.
> There's other posts asking similar questions in the replication discussion
group, from Tanya Milanova and markeboy, but the answers given don't answer
the question about redistribution of the component...
> Cheers, Jim

Conflict between BOL and README - Which one is correct?!

BOL:
Microsoft recommends that you use the built-in account (NT AUTHORITY/SYSTEM)
when installing Reporting Services on a Windows 2000 server. If you use a
domain user account (even one that has local administrator privileges), it
will limit your choices on how to configure a data source connection for a
report as well as introduce new configuration steps that are not otherwise
required.
README-EN:
1.10 Domain user account requirement for subscriptions and ReportServer
Windows service running under Windows 2000 or Windows XP
If the ReportServer Windows service is running under Windows 2000 or Windows
XP, you must configure the service to run under a domain account. If you use
an account that does not have sufficient domain permissions, subscription
delivery will fail when the report server attempts to deliver reports to
domain user accounts. The following error occurs when report delivery fails
due to authorization and domain access issues: Failure sending mail: The
Report Server has encountered a configuration error.
I tried configuring the server using the SYSTEM account, however when
subscription SQL agent jobs are run I get the error listed in README 1.10.
When I reinstall the server and select a Domain Account for the ReportServer
service, I have to use a SQL account to connect. When I try this
configuration, the agent job runs and the Event table is populated, but
nothing else happens. The status shown in the Subscription is that the job
has not run. I'm at a loss. How are the accounts supposed to be configured?
Server is 2000 Advanced server with SQL 2000 Ent Ed.Hi,
I am having exactly the same problem as you report here. Did you get a
resolution to teh problem? If so please let me know!
Thanks
Laurence Neville
"Lifelongstudent" <dveit@.comcast.net> wrote in message
news:uRC9KxVZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> BOL:
> Microsoft recommends that you use the built-in account (NT
AUTHORITY/SYSTEM)
> when installing Reporting Services on a Windows 2000 server. If you use a
> domain user account (even one that has local administrator privileges), it
> will limit your choices on how to configure a data source connection for a
> report as well as introduce new configuration steps that are not otherwise
> required.
> README-EN:
> 1.10 Domain user account requirement for subscriptions and ReportServer
> Windows service running under Windows 2000 or Windows XP
> If the ReportServer Windows service is running under Windows 2000 or
Windows
> XP, you must configure the service to run under a domain account. If you
use
> an account that does not have sufficient domain permissions, subscription
> delivery will fail when the report server attempts to deliver reports to
> domain user accounts. The following error occurs when report delivery
fails
> due to authorization and domain access issues: Failure sending mail: The
> Report Server has encountered a configuration error.
> I tried configuring the server using the SYSTEM account, however when
> subscription SQL agent jobs are run I get the error listed in README 1.10.
> When I reinstall the server and select a Domain Account for the
ReportServer
> service, I have to use a SQL account to connect. When I try this
> configuration, the agent job runs and the Event table is populated, but
> nothing else happens. The status shown in the Subscription is that the job
> has not run. I'm at a loss. How are the accounts supposed to be
configured?
> Server is 2000 Advanced server with SQL 2000 Ent Ed.
>

Confirming Processor Usage

After installing the SQL Server 2000 Standard Edition, how
can one tell that all processors and memory are being used
by SQL Server?
I realize that applications should receive a faster
response time, but there must be a way to check on the
server box itself (or within SQL Server) that it is
utilizing all available processors (or whatever the
maximum number of processors that SQL Server 2000 Standard
Edition is capable of using).
Can someone please let me know as I'm hard pressed right
now to find anything out there that indicates a way of
checking this item.
Thanks.
HouseYou can use the performance monitor tool that comes with Windows. I think
it's actually called System monitor now. There are lots of counters related
to the processors, disks, sql server etc. These may get you going:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly
SQL Server MVP
"Jason House" <jason.house@.ns.sympatico.ca> wrote in message
news:052301c34be0$0143bd80$a101280a@.phx.gbl...
> After installing the SQL Server 2000 Standard Edition, how
> can one tell that all processors and memory are being used
> by SQL Server?
> I realize that applications should receive a faster
> response time, but there must be a way to check on the
> server box itself (or within SQL Server) that it is
> utilizing all available processors (or whatever the
> maximum number of processors that SQL Server 2000 Standard
> Edition is capable of using).
> Can someone please let me know as I'm hard pressed right
> now to find anything out there that indicates a way of
> checking this item.
> Thanks.
> House

ConfigureUnDouble installation help

I am having trouble installing the ConfigureUnDouble tool. I followed all the directions, at least I though i did, and it keeps giving me this error message: "Falure initializing gacutil". I'm not sure if the gacutil.exe is failing or if the dll is not getting created properly. Can anyone help with this?

GACUTIL is a utility that comes as part of the .NET framework. If you open the Visual Studio 2005 Command Prompt and type GACUTIL /?, you should see a list of command line switches. If you don't, something is wrong with your .NET / Visual Studio install.

Configure SSL after installing SQL Server 2000 Reporting Services?

How do you configure SRS to use SSL after you've installed it?First you must configure IIS with a certificate. Once that is done you need
to determine the level of SSL that you want RS to be configured for. You
can find out information for that here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_2xiq.asp
Once you pick a level, just set the SecureConnectionLevel element in the
RSReportServer.config file and you should be up and running.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrik Ylén" <PatrikYln@.discussions.microsoft.com> wrote in message
news:2BFBCC2F-7115-4F9B-ACF4-7FB90E0D1B03@.microsoft.com...
> How do you configure SRS to use SSL after you've installed it?

configure sql server details

Hi everybody,

I'm installing a network monitoring tool (OpManager). During
installation I reached the following step: Configure the SQL Server
details.

Host Name: ?
Port: 1433
Database Name: xxx
User Name: ?
Password: ?

I don't know which host name I need to put in and also I don't know
which user name and password is required.

Please can anyone help me with this.

Thank you!(pearl146@.hotmail.com) writes:

Quote:

Originally Posted by

I'm installing a network monitoring tool (OpManager). During
installation I reached the following step: Configure the SQL Server
details.
>
Host Name: ?
Port: 1433
Database Name: xxx
User Name: ?
Password: ?
>
I don't know which host name I need to put in and also I don't know
which user name and password is required.
>
Please can anyone help me with this.

Since all this is information that is local to your site we cannot really
help you. But we can give some hints:

The host name is usually the machine which SQL Server is running on. If
you have SQL Server on a cluster, it's likely to be the virtual cluster
name. SQL Server can be installed with named instances, in case which
the server is accessed on the form "MACHINE\INSTANCE". I have no idea
what OpManager wants in this case, but since they ask for port number,
I would guess that they stll only want the machine name, and you would
have to use a different port number.

Username and password. By default, SQL Server is installed with
Windows Authentication. This means that when you log into SQL Server,
SQL Server gets your authentication information from Windows, and you
don't supply any user name or password at all. SQL Server can also be
configured for mixed authentication, so that SQL logins are accepted
as well. SQL Logins are username/password pairs.

What username you should specify in this case, I don't know. Probably
you need to create a login and give that the permissions needed by
OpManager. But if your server is not configured for mixed authentication,
there is all reason if you want to activate to run a certain application.
I would expect the app to work with Windows Authentication as well.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx