How To Configure SQL Server 2005
Dec 17, 2007
Hi All,
I am new to SQL server 2005. I have installed SQL server 2005 which came along with the visual studio 2005 package. Now i could see the visual studio 2005 in the installed programs list.
I really dont know how to configure the the installed SQL server. how to create tables and veiw. frankly speaking i could not see where is the head and tail.
To be straight forward, i havent used any database to a great extent. earlier during the starting of my career, i developed a small application using VC++, which used to interact with the DB server on a very minor scale; whenever i wanted to create a table for used to do it with sql client which was also installed in my machine.
currently i am againg devoloping a small apliccation using VC++, this time for devlopment and testing purposes, I have SQL server 2005 installed in the same machine which i am using for development.
Now as i said eralier i am not even aware how to configure, how to start creating table...... :-(
all i have done is i have installed SQL server 2005 and all i could see is SQL Server 2005 listed in the installed programs list :-(
some one please help me.... :-(
I couldnt even create a DSN
Thanks and Regards
RK
View 1 Replies
ADVERTISEMENT
Jan 3, 2007
Login failed for user ''. The user is not associated with a trusted SQL Server Connection.
Ive got this error... I have just installed the SQL Server 2005 Standard Edition. Could anyone encounter and solve this problem.. please til me how to solve this. I google this but couldnt find a reliable solution for this..
Thanx...!
-------------------
Real Programmer dont document
If its hard to write Then
its easy to undertand.
End If
View 10 Replies
View Related
Jul 26, 2006
With Linked server you can access DB2 resources as if it is another object in your SQL Server.
You don€™t have to establish links from all nodes to the DB2 Server.
Connection from SQL server 2005 to DB2 Server is sufficient to all SQL server users to access DB2 resources.
1. Install MicroSoft OLE DB provider For DB2 in SQL server 2005.
2. configure as follows:
Start - - -> all programs - - - > MicroSoft OLE DB provider For DB2 - - - > Data Access Tool.
Right click on data sources - - -> New Data Source
In Data Source Wizard - - > Data Source plat form = DB2/MVS or any other appropriate plat form from drop down
Net work type = TCP/IP - - > Next
Address = IP address:xx.xx.xx.xx
Port Number: xxxxxxx - - -> Next
Initial Catelogue = SAMPLE
Package Collection = DB2INST1
Default schema = DB2INST1
Default Qualifier = Leave it blank - - -> NEXT
HOST CCSID = EBCDIC- U.S./Canada[37] or appropriate one
P.C Code Page = ANSI-Latin I[1252] or appropriate one
Process Binary as character = check the box - - -> NEXT
Interactive sign on - - - > select it
Provide login name and password.
Check "Allow Password saving" - - - -> NEXT
Check appropriate boxes like read only etc. - - -> NEXT
Click Connect tab - - -> make sure "Success ful" message is appearing
Example: - "Successfully connected to data source 'DB2-server'.
Server class: DB2
Server version: 8021.00.0000"
- - - -> NEXT
Provide a data source name.(Example: DB2-Server)
Check initialization string option - - - > NEXT
Review completed task list on the window and
Select "FINISH" to complete the work.
The data source which you have added just now(DB2-Server) will be appearing on the grid now.
right click on the data source name and make a note of the path where it has formed
right click on the data source name and click "Display connection string"
cut and paste this connection string on the lower window to note pad for future use.
Start MS SQL server Management studio
Add a fresh linked server in 'SQL Server - - > Server Objects - - -> Linked Server" as follows:
Click Mouse right button on linked server and select "New Linked Server"
linked server = Provide a meaning ful, fully identifiable name for Linked server(Example"DB2-Linux")
Provider = MicroSoft OLE DB provider For DB2
Product name = DB2OLEDB
Data source = IP address
Provider string = Paste the connection string pasted to note pad earlier.
Location = Leave it blank
Catalog = SAMPLE
Click on security on the left side pane
Provide an SQL Server login from the drop down
Do not select check impersonate
Provide DB2 username and password and remote user name and password.
Click OK to save.
You will find the name of liked server appearing below the object Linked Server(Example "DB2-LINUX")
Open a new query window and execute an open query
Example:
SELECT * FROM OPENQUERY("DB2-LINUX", 'SELECT * FROM SAMPLE.DB2INST1.EMPLOYEE')
In the Example "DB2-LINUX" is the name of the linked server
"SAMPLE.DB2INST1.EMPLOYEE" is the name of the table. Sample = name of the db
DB2INST1= name of schema to which the table belongs to
Employee = name of the table
Another Example would be
SELECT empno,FIRSTNME FROM OPENQUERY("DB2-LINUX", 'SELECT * FROM SAMPLE.DB2INST1.EMPLOYEE')
View 1 Replies
View Related
Jul 21, 2006
Arghh ...
I have searched all the newsgroups and applied or tried all the suggestions, with no success. I have completely uninstalled and reinstalled SQL 2005.
Can someone point me in the right direction? Here is the error I receive when I try to 'Configure Distribution' in the SQL 2005 management studio.
Any/all help is greatly appreciated.
Tery
PS. The destination path mentioned in the error is definitely a correct path.
TITLE: Microsoft.SqlServer.ConnectionInfo
------------------------------
SQL Server could not configure 'LAPTOP' as a Distributor.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
An error occurred during the execution of xp_cmdshell. A call to 'CreateProcess' failed with error code: '5'.
Invalid destination path C:Program FilesMicrosoft SQL ServerMSSQLData.
Changed database context to 'master'. (Microsoft SQL Server, Error: 15121)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15121&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
View 4 Replies
View Related
Nov 14, 2006
Hi there! I've been trying for several days now to configure SQL Server 2005 to allow remote connections, apparently, with no luck.
I always have this error message: Microsoft SQL Native Client: 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.
I've followed the instructions at this link -> http://support.microsoft.com/?kbid=914277&SD=tech, but I have been having the same problems.
I've already adjusted my firewall settings.
What should I do?
Please help me...
View 2 Replies
View Related
Jan 17, 2007
Hello there,
I just deployed a new ASP.NET 2.0 website on a remote server http://www.alrazem.com/. and when i want to log on, or when any connection to the database happens!! the following error ocurs.
Server Error in '/' Application.
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Anyways, I searched the new. and i found this link: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277... I followed the instructions and changed the Surface Area Configuration for Services and Connections to Local and remote connections. and Applied both protocols. Then redeployed the application. but the error still ocurs.
I didn't restart my machine after changing the SQL to remote. but i did the website from scratch again. and created a new connectionstring and database!!!
Any help? Thanks!
View 1 Replies
View Related
Nov 15, 2007
Ok. Here is what I need to do: several computers on the intranet need to use a client program to access data from the server (a desktop)
Here is what is going on:
1. I am using Visual Studio 2005 c#.net 2.0
2. Sql Server Express 2005
3. I don't have IIS set up
4. The database is being shared from the c drive on the server (not sophisticated at all, but this is a one man operation!)
Questions:
1. Is IIS an absolute must to make this happen?
2. If not, a user pointed out that I can't use UNF to access the database. How do I set up the connection string to access the db on the server?
This is my basic connection string (local)
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:MonzaDBMonzaDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;Asynchronous Processing=true"
Thanks for any help on this subject. I know basically nothing about NETWORK programming and database administration!
View 4 Replies
View Related
Aug 15, 2006
Hello. I have SQLEXPRESS 2005 installed on my laptop running Windows XP Home Edition with SP2. I have an application that can connect to the local instance with no problem. The other day, I tried to configure SQLEXPRESS 2005 for a remote connection from my desktop. To date, I have been unable to figure out how to do this.
I have followed the instructions posted at various locations on the internet, but to no avail. While I can configure SQLEXPRESS 2005 to allow TCP/IP connections, I have been unable to restart the server.
Here is the pertinent snippet from the error log:
<time> Server A self-generated certificate was successfully loaded for encryption.
<time> Server Error: 26024, Severity: 16, State: 1.
2006-08-14 21:02:27.18 Server Server failed to listen on 'any' <ipv4> 0. Error: 0x277a. To proceed, notify your system administrator.
<time> Server Error: 17182, Severity: 16, State: 1.
<time> Server TDSSNIClient initialization failed with error 0x277a, status code 0xa.
<time> Server Error: 17182, Severity: 16, State: 1.
<time> Server TDSSNIClient initialization failed with error 0x277a, status code 0x1.
<time> Server Error: 17826, Severity: 18, State: 3.
<time> Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
<time> Server Error: 17120, Severity: 16, State: 1.
<time> Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
I have a feeling this problem is due to the way my system is configured, not necessarily how my SQLEXPRESS 2005 is configured. My laptop and desktop are connected via a wireless router, and both machines are running Norton Anti-Virus 2006. I've added sqlserver.exe and sqlbrowser.exe to the exceptions list for the Worm protection on the laptop, i.e., the server machine. There's not a setting at the router that would prevent the server from re-starting, is there?
Any help is GREATLY appreciated!
Matt
View 15 Replies
View Related
Nov 13, 2007
Hi
As you know SQL Express by deefault accepts only local connections
For a particular requirement i have to change SQL Server Surface Area Configuration to accept remote connections by dos command
Anyone know this command?
thanks
Marco
View 16 Replies
View Related
Apr 19, 2008
hi,
could anyone guide me on how to allow, ceate rule for sql server 2005 remote connections to work. i already configured my sql server to allow remote connections and also my router, it is only in isa that is blocking the connections.
thanks
View 1 Replies
View Related
Apr 21, 2008
Hi,
I have a Windows 2008 server 64-bit SP1 and I have installed SQL 2005 SP2 Enterprise Edition 64-bit. My current version is 9.00.3042.00. I am trying to configure Reporting Services and I am having lots of trouble getting the Application Pools to work properly. I have followed the Microsoft Technet paper 839480 "How to Install and Configure Reporting Services on Windows Server 2008". In the "Configure Reporting Services" part, I have successfully configured everything (all arrows are green) and have the following setup:
Report Server Virtual dir: ReportServer Default Web Site
Report Manager Virtual dir: Reports Defualt Web Site
Windows Service Identity: ReportServer with a service acct login
Web Service Identity:
Report Server: ReportServer,
Report Manager: DefaultAppPool (I get an error when I try to configure it to anything else: ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
The one thing I notice in the SQL Server configuration manager is that there is a red dot next to the SQL Reporting Services services even though the green arrow is there to show it is running.
When I look in IIS7, I see the application pools Reports and ReportServer and they are both in Integrated mode. When I try to go to http://localhost/reportserver, it gives an error. It will work if I change both application pools to classic. But then when I try to go to http://localhost/reports, I get an error:
"REQUEST IS NOT AVAILABLE IN THIS CONTEXT".
I have read up on IIS7 and it says that:
"This error is due to a design change in the IIS7 Integrated pipeline that makes the request context unavailable in Application_Start event. When using the Classic mode (the only mode when running on previous versions of IIS), the request context used to be available, even though the Application_Start event has always been intended as a global and request-agnostic event in the application lifetime."
So, how do I configure these application pools to work using IIS7 with SQL 2005 Reporting Services on a Windows 2008 server? I have tried all kinds of different things based on what I am reading on the net and nothing is working. Anybody have any suggestions?
Thanks!
Isabelle
View 3 Replies
View Related
Sep 12, 2006
I am attempting to insert information from Visual Web Developer 2005 using either the Gridview or Datalist controls into a SQL Server 2005 database and get stuck when defining the custom statement.When I enter the text within the insert tab, the <next> button remains greyed out, preventing me from continuing to the next page.If I copy the same text into the select tab, then I can continue with the wizard, however this raises other problems which may or may not be related (multiple insertions of the data into the SQL Server database table - possibly due to postback functions). I would rather use insert to confirm that my second problem is not because I am using the wrong option.My question is:Should I be able to use the insert function within VWD express or is this only available within the standard/pro editions?
View 2 Replies
View Related
May 30, 2007
I am trying to configure distributed transaction and XA support using Microsoft SQL Server 2005 JDBC Driver. I have coppied SQLJDBC_XA.dll from XA directory and placed in my sql server binn directory and trying to run the script xa_install.sql from binn directory with command as below :
C:Program FilesMicrosoft SQL Server80ToolsBinn>
osql -U sa -n -P admin -S localhost -i C:JavaLibrariesMS SQL Driversqljdbc_1.2enuxa xa_install.sql
But I am getting error saying :
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
when I replaced local host with the machine name it gives error :
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
where in I am able to test connection from Websphere using the same connection.
Please help some one ....... I am in URGENT need.... I need to enable XA suport for my application to run........
Thanks ----
View 2 Replies
View Related
Sep 13, 2007
Hello, everyone:
I hope my question is clear.
I have SQl Server 2005 installed in local computer. I am planning to create report by Report Service so a report server is needed by which I can deploy report from my local computer to that server. How to intall the report server in another computer/
Thanks
ZYT
View 1 Replies
View Related
Jun 10, 2007
Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?
I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.
For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.
Any insights?
View 1 Replies
View Related
Mar 5, 2008
Hi all,
For the first time, I want to set up the configuration of my SQL Server Management Studio Express (SSMSE) to allow me in doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. The SSMSE and VB 2005 Express are in my Windows XP Pro PC that is part of our NT 4 LAN System in our office. I read the article "How to configure SQL Server 2005 to allow remotre connections" in http://support.microsoft.com/kb/914277/ about (i) "Enable remote connections for SQL Server 2005 Express", (ii) Enable the SQL Server Browser service", (iii) Create exception in Windows Firewall, and (iv) Create an exception for the SQL Server Browser service in Windows Firewall. I entered the SQL Server Surface Area Configuration and I could not decide what options I should take for doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. I have the following questions on the page of "Minimize SQL Server 2005 Surface Area":
(1) I saw "Configure Surface Area for localhost [change computer]". I clicked on [change computer] and I saw the
following: Select Computer
The Surface Area Configuration of this surface area of this computer or a remote computer.
Specify a computer to configure: O Local computer
O Remote computer
Should I choose the "Local computer" or the "Remote computer" option?
(2) Below the "Configure Surface Area for localhost [change computer]",
I clicked on "Surface Area Configuration for Service and Connections", Select a component and then configure its services and connections: |-| SQLEXPRESS
|-| Database Engine
Service
I picked => Remote Connection
On the right-hand side, there are: O Local connections only
O Local and remorte connections
O Using TCP/IP
O Using named pipes only
O Using both TCP/IP and named pipes
Should I choose O Local and remorte connections and O Using named pipes only?
Please help and tell me what options I should choose in (1) and (2).
Thanks in advance,
Scott Chang
View 10 Replies
View Related
Mar 6, 2008
i have trackit!6.5 application which works as follow:
when installing it and if there is no sql server is installed then he install sql desktop and the application works fine
now i want to use sql server 2005 instaed so i keep getting that error
login failed for user trackit65 also i added myself
so any idea ??
which schema or member ship shall i use
also i got error event id 18456 with no ERROR STATE listed with it
View 1 Replies
View Related
Jul 26, 2006
I€™m interested in reading about best practices or
recommended deployments for MS SQL 2005.
Currently our company owns 8 x SQL 2005 Enterprise Processor licenses. We have 4 HP DL380€™s with the following
configurations:
6GB RAM
Mirrored
72GB drives for OS (Windows 2003 Ent R2)
4TB Shared
storage (SAN) (15K Fiber Channel)
Dual 3.6GHz
Processors
We would like to create a highly available data
warehouse. We considered running the
SQL engine on one set of servers (Cluster 1) and running the reporting, analysis,
browser, etc., services on the other set of servers (Cluster 2).
Is this possible with MS SQL 2005?
How do we install and link all the servers together?
Is this a poor design?
With the above hardware and software, what would be the best
deployment for availability, distributed processing, speed, and reliability and scalability?
Thank you.
=G
View 1 Replies
View Related
May 15, 2008
Hi folks,
I am exploring various solutions to setting up a scalable database configuration. To do a proof of concept, I need to setup the database in such a way that the data is partitioned on 2 physical machines.
I looked at distributed partitioned views, which allowed me to create a table on databases residing on two different servers, and then I created distributed view (with appropriate range constraints) that supported distributed selects, joins, updates, and inserts. This seemed to be the solution we were looking for.
However, I ran into a major problem because of the fact that distributed partitioned views don't allow a table to maintain an Identity column with an identity seed.
I did more research and found the Partitioned Table concept that was introduced in SQL 2005. This partitioned table allows us to have a single table which is horizontally partitioned across multiple file groups. This table now is just like a regular table in that it supports the identity column and identity seeds and guarantees index integrity. We were successful in implementing the partitioned table on a single machine, with three filegroups.
Now I need to move these file groups to different physical machines. I have found some articles on adding file group on additional hard disks on the same machine - but nothing to setup a database that is comprised of multiple servers that each handle a part of the data partition.
Is it possible to create a database comprise of filegroups residing on different physical machines?
Thanks.
View 12 Replies
View Related
Apr 29, 2008
Hi,
I have installed SQL Reporting Service on one server. Using the config tool, I am trying to setup the Reporting Database on a seperate SQL instance. This SQL instance is running on a Clustered SQL 2005 server.
The creation of the Database is sucessful. However when I give the Windows credentials to connect to this database on the same page, I always fail at the following task : Setting Connection Info for Reporting Server. The error message is :
"System.Runtime.InteropServices.COMException (0x800706B3)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.Get()
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetDatabaseConnection(String server, String database, ConfigurationCredentialsType credsType, String userName, String password)"
The Windows Account I am using has Full SQL Rights to the Clustered SQL Server. I have seen other posts on the forums about the 0x800706B3 error, but most of them are related to a problem with RPC.
The Reporting Services account is runing under 'Network Services'. I am not sure if this is causing the problem?
Thoughts anybody?
Thanks,
Mahmood
View 8 Replies
View Related
Mar 19, 2001
Hello All,
We've A2k db which we plan to migrate to SQL 7.0 very soon. Though am familiar with upsizing wizard BUT don't know how to configure Access forms, reports etc. to talk to SQL back end tables. So that information entered via Access forms can be stored in sql and reports can be generated using sql tables..
Thanks in advance..
View 1 Replies
View Related
Oct 27, 1998
What are the steps in configuring sql server 6.5 to have excellent performance?
what are the items that I should think of and based on what condition I can set up the configuration?
Ahmed
View 1 Replies
View Related
Jul 20, 2005
Hi All,Here is my questionWhat might you configure on a SQL Server so that a Web server runningon the same machine, with limited memory, will continue to performoptimally?Thank youRaju
View 1 Replies
View Related
Nov 14, 2006
I have searched and could not find an answer for this one I read log and it said
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
how do I fix this?
View 7 Replies
View Related
Jun 7, 2000
Hi all,
I'm having a problem configuring one of my SQL servers
as a distributor. I've done it successfully on another
server, so I know that it's nothing procedural and there
must be an issue with the way the server is set up.
When I click 'finish' on the Configure Publication and
Distribution Wizard, I get the following error message:
Enterprise Manager could not configure 'ABEL' as the
distributor for 'ABEL'.
Error 20017: Cannot add the remote distributor at this time.
Make sure that the local server is configured as a Distribution
Publisher at the Distributor.
Can anyone point me in the right direction? I'm fairly new
to SQL Server, so feel free to explain things in a
condescending manner. ;-)
View 1 Replies
View Related
Mar 19, 2003
I have a SQL Server version 7.0 and want to configure IBM DB2 on OS 390 as a linked server on it . I installed DB2 clients on the SQL Server and thru DB2 Connect ,I am able to access the mainframe data using the clients . However I am having problems configuting the Mainframe server using IBM DB2 OLE DB Driver .I am not sure if we need to use Microsoft OLE DB Driver .
View 3 Replies
View Related
Nov 28, 2003
Our company is going to use SAN (HP or EMC or Fuji) for SQL Server failover rather than MSCS. So far, DBA has no knowledge of SAN.
Would you please to tell me, how does SAN depend on SQL Server? I assume SAN software can make disk failover if there is a network, disk or OS failure in primary node. If SQL Server or SQL Agent is failure, can SAN software detect it? (or can SAN disk failover depend on SQL Server or SQL Agent services?)
Please let me know where can I find any configuration document regarding SAN for SQL Server failure. I had spent 2 days in HP and EMC wrbsite and found nothing.
Happy Thanksgiving.
Mary
View 5 Replies
View Related
Mar 10, 2001
hi there!
i have been trin to configure my network for the sql server 6.5 but in vain.Actually
i have two pc in the network , one is server and the other is workstation.i install
SQL server on the NT server and then install the sql client oon the workstation but i
donno how to configure that client for the server.
so i just want u leet me that what particular steps should i follow to make that
network work properly for the sql server 6.5. i just wanna use sql server 6.5 in a
simple situation. i am not an advance user of the sql server 6.5.
i will be greatful to GOD if uu help in this problem.
sincerely,
romanafroz@hotmail.com
View 1 Replies
View Related
Oct 4, 2005
Hello, everyone:
I want to create a stored procedure to execute validation and send results to clients. When I did testing to send email by:
EXEC master..xp_sendmail
@recipients='you@you.com',
@message = 'Validation Finished',
@subject = 'foo was fired.'
I got error loke:
Server: Msg 18030, Level 16, State 1, Line 0
xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
How to configure Outlook and SQL Server Email next?
Thanks
ZYT
View 1 Replies
View Related
Feb 13, 2004
Hi all,
Please, tell me how to configure database SQL server 2000 for a large system, and make it uninterrupted run.
Thanks
View 6 Replies
View Related
May 11, 2004
Hi,
I have installed MS SQL Server on a win XP and a MS SQL Server client on a win2000. I don’t know how to configure this client to access the server remotely.
Any pointer?
Thanks.
I am very new to SQL Server.
View 7 Replies
View Related
Jan 25, 2008
When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace
What is the problem and how to solve it.
View 4 Replies
View Related
Oct 19, 2007
Hi everybody,I'm installing a network monitoring tool (OpManager). Duringinstallation I reached the following step: Configure the SQL Serverdetails.Host Name: ???Port: 1433Database Name: xxxUser Name: ???Password: ???I don't know which host name I need to put in and also I don't knowwhich user name and password is required.Please can anyone help me with this.Thank you!
View 1 Replies
View Related
