Cant telnet x.x.x.x 1433 on localhost

Hi,
I used Microsoft SQL server 2000 on Microsoft Windows Server 2003 for database server and used Redhat Linux Enterprise for Web server.

I wrote the PHP script (on Redhat) connect to database server, its does not work. And then I install freetds on Web server but not work too.

I have problem not be solve...
- on Redhat, cannot telnet x.x.x.x 1433 to database server. But telnet to other port is success.
- on database server, cannot telnet x.x.x.x 1433 and telnet 127.0.0.1 1433.
- between web server and database server can used ping !
- I used command 'netstat -an' on database server is not show for 1433 port.

please help me... :eek:My first guess would be that you have NOT applied SQL 2000 service pack 3a or later to your SQL Server machine. Windows 2003 will not allow SQL Server to use TCP/IP unless it is protected from the Blaster worm.

-PatP|||thank you :)

Can't start SSIS

Hello,

Our enterprise have bought a sql server 2005 standard edition.
Before installing it i have installed the beta version.
And after I desinstalled this beta version (with difficulties).
But the problem is that I can't start SSIS.

I have the following message:
"The request failed or the service did not respond in a timely fashion.
Consult event log or other applicable error logs for details."

Please can you help me.
Thanks.

You should really format the machine and reinstall the OS, especially if you had an early beta. The fact that you had problems cleaning it up would be a clear indication to me that you should do that more than ever.

Are there any errors in the event log, as the message directs?

Have you applied SP1? There is an issue with starting the service with that.

|||If you have installed SP1, please review this KB article
http://support.microsoft.com/kb/918644|||

Thanks!!!
In fact I haven't installed the SP1 because the SP1 I have seen is only for express edition (I have the standard edition)!!
For the event log I haven't seen it yet!! I'll try to do it Monday.

PS:
One thing I remembered during the installation is that all the system requirements were not OK.I didn't have errors but there were 2 warnings(i don't remember them)!! .

May be it will be that!!Or it will be because I haven't installed SP1 (if you know where I can download it please indicate me ).

Thanks for comments!!!

|||

taze wrote:

if you know where I can download it please indicate me

The SP1 can be downloaded http://www.microsoft.com/sql/sp1.mspx, but I don't think it will fix this particular issue.

I join Darren's advice to reinstall the OS if earlier it had any beta builds.

|||Thank U very much for your advice!!!
I will try reinstall SQL Server 2005 in a new machine wirhout any SQL 2005 beta version!!!
Thanks!!!

Can't start Query Analyzer on SQL Cluster

Have you experienced such problem in a Windows Cluster environment :
Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
Error : The Query Analyzer could not be started on the first node :
ISQLW.EXE - Entry Point Not Found
The procedure entry point ''? could not be located in the dynamic
link library SQLGUI.dll.>
> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise
Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ''? could not be located in the dynamic
> link library SQLGUI.dll.
--
It's possible the SQLGUI.DLL is corrupt. Rename the file in the cluster and
copy from a machine which works.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.|||> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ''? could not be located in the dynamic
> link library SQLGUI.dll.
>
>
How did you solve this problem?
User submitted from AEWNET (http://www.aewnet.com/)|||> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ''? could not be located in the dynamic
> link library SQLGUI.dll.
>
>
How did you solve this problem?
User submitted from AEWNET (http://www.aewnet.com/)

Can't start Query Analyzer on SQL Cluster

Have you experienced such problem in a Windows Cluster environment :
Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
Error : The Query Analyzer could not be started on the first node :
ISQLW.EXE - Entry Point Not Found
The procedure entry point ??? could not be located in the dynamic
link library SQLGUI.dll.
>
> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise
Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ??? could not be located in the dynamic
> link library SQLGUI.dll.
It's possible the SQLGUI.DLL is corrupt. Rename the file in the cluster and
copy from a machine which works.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
|||
> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ??? could not be located in the dynamic
> link library SQLGUI.dll.
>
>
How did you solve this problem?
User submitted from AEWNET (http://www.aewnet.com/)
|||
> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ??? could not be located in the dynamic
> link library SQLGUI.dll.
>
>
How did you solve this problem?
User submitted from AEWNET (http://www.aewnet.com/)

Can't setup replication: Encryption error using CryptProtectData?

I am trying to setup replication but am having the following issues
Publisher:
SQL 2005 SP1 Enterprise Cluster (Active, Passive)
Subscriber:
SQL 2005 SP1 Enterprise


When trying to create a publication or subsubscription running under a Windows Domain account the following error message appears:

Replication-Replication Distribution Subsystem: agent ECHO\ECHO-InsDB-INS_CMS_PUB-HARPO-58 failed. Unable to start execution of step 2 (reason: Error authenticating proxy DETINI\srvRep_user, system error: Logon failure: unknown user name or bad password.). The step failed.

Further in the SQL logs we find that the above message is due to:

[298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]

It appears that when Credentials for the agent proxy are being created that this message occurs. So when the SP that tries to run the agent (snapshot or distrobution) is called it always returns incorrect password details.

The Credentials do appear to be created, they are visible via SQL Studio, but you can't see the password. Changing the password via SQL Studio does not work as the Credentials are recreated every time.

I have checked the following:

MSDTC is running correctly
The Domain Account has the correct privileges to run these services
Regenerated the Service Master Key
Created Master Keys in each database effected by replication
Ensure SQL Service accounts have access to decrypt the Service Master Key
I can create a Publication and Subscription using the local system account on the cluster

Does anyone have any idea ?

Chris

Chirs,

My testing environment is the same as yours - the publisher/distributer is clustered SQL2005 enterprise with SP1 on windows 2003, and the subscriber is SQL2005 enterprise on 2003 server, and I have got the same error when I was trying to run the creating snapshot job. The only workaround I found was to put the distributor on the same server as the publisher, and use a local directory for shapshot folder, which was not ideal, but at least I could continue with my test. Then I had the same error again when I ran the push distribution job using a domain ammount. I had to change the security to use SQL agent account, which is a domain admin account.

I would like to know how to avoid the error too, since I want the distributor to be on a different machine than the publisher, and limit the rights of the credentials on the production environments.

Ying

sql

Can't setup replication: Encryption error using CryptProtectData?

I am trying to setup replication but am having the following issues
Publisher:
SQL 2005 SP1 Enterprise Cluster (Active, Passive)
Subscriber:
SQL 2005 SP1 Enterprise


When trying to create a publication or subsubscription running under a Windows Domain account the following error message appears:

Replication-Replication Distribution Subsystem: agent ECHO\ECHO-InsDB-INS_CMS_PUB-HARPO-58 failed. Unable to start execution of step 2 (reason: Error authenticating proxy DETINI\srvRep_user, system error: Logon failure: unknown user name or bad password.). The step failed.

Further in the SQL logs we find that the above message is due to:

[298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]

It appears that when Credentials for the agent proxy are being created that this message occurs. So when the SP that tries to run the agent (snapshot or distrobution) is called it always returns incorrect password details.

The Credentials do appear to be created, they are visible via SQL Studio, but you can't see the password. Changing the password via SQL Studio does not work as the Credentials are recreated every time.

I have checked the following:

MSDTC is running correctly
The Domain Account has the correct privileges to run these services
Regenerated the Service Master Key
Created Master Keys in each database effected by replication
Ensure SQL Service accounts have access to decrypt the Service Master Key
I can create a Publication and Subscription using the local system account on the cluster

Does anyone have any idea ?

Chris

Chirs,

My testing environment is the same as yours - the publisher/distributer is clustered SQL2005 enterprise with SP1 on windows 2003, and the subscriber is SQL2005 enterprise on 2003 server, and I have got the same error when I was trying to run the creating snapshot job. The only workaround I found was to put the distributor on the same server as the publisher, and use a local directory for shapshot folder, which was not ideal, but at least I could continue with my test. Then I had the same error again when I ran the push distribution job using a domain ammount. I had to change the security to use SQL agent account, which is a domain admin account.

I would like to know how to avoid the error too, since I want the distributor to be on a different machine than the publisher, and limit the rights of the credentials on the production environments.

Ying

Can't see mapped drives

Hi,
Am unable to see mapped drive when going to restore db in
sql 2000 enterprise manager. Service is set to start
with a lan acct. acct is in the local machine admin grp
and remote machine admin grp.
Any suggestions:-)
Thanks in advanceDo not use mapped drives for backup\restore with SQL server. Use UNC names
instead. SQL may or may not see a mapped drive correctly but will always
find a UNC share that it has permission and connection to.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||Hi,
You cant see the mapped drives in Enterprise manager. Rather you can
directly mention the UNC path directly in Enterprise manager or use
Restore database command from Query Analyzer.
Restore database <dbname> from disk='\\machinename\share\backupfile.bak'
with stats=10 With
Move 'logicaldatafile' to physcaldatafile',
Move 'logiallogfile' to physcallogfile'
stats will show the restore status
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||It is possible to get SQL Server to use mapped network drives, through the u
se of trace flag 1807.
Check out knowledge base article #304261 for full details
http://support.microsoft.com/defaul...1&Product=sql2k

Can't see database in enterprise manager

When connecting to server using enterprise manager it
shows tree view but won't allow me to see datbases? I f I
stop and start the service it says something lik ean error
1056(an instance of service already running) can't find a
solution anywhere getting desperate. pleas ehelp A.S.A.P.Have you logged on using sa ? Is is the same kinda view when you open
Enterprise Manager from other clients that have connectivity to the server ?
What about from Query Analyser ? Can you connect and do you see all
databases ?
"johnboy" <anonymous@.discussions.microsoft.com> wrote in message
news:12c901c4a2e9$ba258fc0$7d02280a@.phx.gbl...
> When connecting to server using enterprise manager it
> shows tree view but won't allow me to see datbases? I f I
> stop and start the service it says something lik ean error
> 1056(an instance of service already running) can't find a
> solution anywhere getting desperate. pleas ehelp A.S.A.P.|||"johnboy" <anonymous@.discussions.microsoft.com> wrote in message
news:12c901c4a2e9$ba258fc0$7d02280a@.phx.gbl...
> When connecting to server using enterprise manager it
> shows tree view but won't allow me to see datbases? I f I
> stop and start the service it says something lik ean error
> 1056(an instance of service already running) can't find a
> solution anywhere getting desperate. pleas ehelp A.S.A.P.
Log in as SA user and check read permissions in sysdatabase table in master
database.
Dra

Can't see database in enterprise manager

When connecting to server using enterprise manager it
shows tree view but won't allow me to see datbases? I f I
stop and start the service it says something lik ean error
1056(an instance of service already running) can't find a
solution anywhere getting desperate. pleas ehelp A.S.A.P.
Have you logged on using sa ? Is is the same kinda view when you open
Enterprise Manager from other clients that have connectivity to the server ?
What about from Query Analyser ? Can you connect and do you see all
databases ?
"johnboy" <anonymous@.discussions.microsoft.com> wrote in message
news:12c901c4a2e9$ba258fc0$7d02280a@.phx.gbl...
> When connecting to server using enterprise manager it
> shows tree view but won't allow me to see datbases? I f I
> stop and start the service it says something lik ean error
> 1056(an instance of service already running) can't find a
> solution anywhere getting desperate. pleas ehelp A.S.A.P.
|||"johnboy" <anonymous@.discussions.microsoft.com> wrote in message
news:12c901c4a2e9$ba258fc0$7d02280a@.phx.gbl...
> When connecting to server using enterprise manager it
> shows tree view but won't allow me to see datbases? I f I
> stop and start the service it says something lik ean error
> 1056(an instance of service already running) can't find a
> solution anywhere getting desperate. pleas ehelp A.S.A.P.
Log in as SA user and check read permissions in sysdatabase table in master
database.
Dra

Can't see all drives in a cluster within Enterprise manager

When I am in Enterprise Manager to create a new database, I click on the location of the data and log file, I only see 1 drive where SQL Server was installed...How do I get SQL Server to display all the other drives the node owns in the cluster? I can view them under My Computer and within the Cluster Administrator. Each node owns it's own drives. But I should be able to see all drives owned by the node when browsing to create a new database so I can assign different drives for the Data and Log files.
Any ideas would be helpful
Thanks
WarrenPerhaps you have to restart SQL Server?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:B873E1EB-030A-41F4-910A-1F15FE1A2D7B@.microsoft.com...
> When I am in Enterprise Manager to create a new database, I click on the location of the data and
log file, I only see 1 drive where SQL Server was installed...How do I get SQL Server to display all
the other drives the node owns in the cluster? I can view them under My Computer and within the
Cluster Administrator. Each node owns it's own drives. But I should be able to see all drives
owned by the node when browsing to create a new database so I can assign different drives for the
Data and Log files..
> Any ideas would be helpful,
> Thanks,
> Warren|||Dear Tibor
I will try it and let you know
Thanks
Warren|||Dear Tibor,
Same result. Still can't see all the drives?|||Sorry, that was just a wild guess...
Re-reading your original post, you say that you only see the drive where SQL Server was installed.
Do you mean the local drive? That would imply, methinks, that you didn't install the SQL Server as a
clustered SQL Server. SQL Server should not show the local drives when creating databases etc, it
should only show the "shared" drives.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:7B544C67-CF57-4D8B-B726-3C259486A975@.microsoft.com...
> Dear Tibor,
> Same result. Still can't see all the drives?|||I found the answer. After a successful install of SQL Server on the cluster and testing fail-over. You have to take one node off-line and add dependencies (IE. the other drives) to the SQl Server , bring that node back on-line and repeat for the other node. This should be your last step then, re-test failover and moving the cluster between nodes
Whew
Thanks
Warren

Can't see all drives in a cluster within Enterprise manager

When I am in Enterprise Manager to create a new database, I click on the loc
ation of the data and log file, I only see 1 drive where SQL Server was inst
alled...How do I get SQL Server to display all the other drives the node own
s in the cluster? I can vi
ew them under My Computer and within the Cluster Administrator. Each node o
wns it's own drives. But I should be able to see all drives owned by the no
de when browsing to create a new database so I can assign different drives f
or the Data and Log files..
Any ideas would be helpful,
Thanks,
WarrenPerhaps you have to restart SQL Server?
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:B873E1EB-030A-41F4-910A-1F15FE1A2D7B@.microsoft.com...

quote:

---

> When I am in Enterprise Manager to create a new database, I click on the location of the d
ata and

---

log file, I only see 1 drive where SQL Server was installed...How do I get S
QL Server to display all
the other drives the node owns in the cluster? I can view them under My Com
puter and within the
Cluster Administrator. Each node owns it's own drives. But I should be abl
e to see all drives
owned by the node when browsing to create a new database so I can assign dif
ferent drives for the
Data and Log files..

quote:

---

> Any ideas would be helpful,
> Thanks,
> Warren

---

|||Dear Tibor,
I will try it and let you know.
Thanks,
Warren|||Dear Tibor,
Same result. Still can't see all the drives?|||Sorry, that was just a wild guess...
Re-reading your original post, you say that you only see the drive where SQL
Server was installed.
Do you mean the local drive? That would imply, methinks, that you didn't ins
tall the SQL Server as a
clustered SQL Server. SQL Server should not show the local drives when creat
ing databases etc, it
should only show the "shared" drives.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:7B544C67-CF57-4D8B-B726-3C259486A975@.microsoft.com...

quote:

---

> Dear Tibor,
> Same result. Still can't see all the drives?

---

|||I found the answer. After a successful install of SQL Server on the cluster
and testing fail-over. You have to take one node off-line and add dependen
cies (IE. the other drives) to the SQl Server , bring that node back on-line
and repeat for the other n
ode. This should be your last step then, re-test failover and moving the cl
uster between nodes.
Whew!
Thanks,
Warren

Cant run query today that ran yesterday

I converted an MS Access db to SQL Server 2005 Express yesterday. I used FullConvert Enterprise for the conversion and it worked great. I ran several queries and saved them, and they ran fine. Today, running the same queries, I get this error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'tblTXMup'

I googled the message and found someone who had a similar problem and their answer was they were not the dbo. I checked the new database and it was owned by sa so I logged in as sa and got the same error.

Can anyone set me straight so I can get into this db?

Thanks,probably you are executing your query in the context of some other database, not the one you created yesterday.|||The error seems to suggest that the object that you referenced doesn't exist in the schema.

Regards,|||Thanks for looking at this. I only converted the one database so I know it is the right one. I can display the table I am trying to query, so I know I am logged in to the right one. The query was saved from yesterday and it got a result then but throws the error now.

Any other ideas?

Thanks,|||Sure,

Can you execute a query (or if you fancy, a DML statement for a change) against the table. It is important to differentiate between just seeing the table listed as a database object and the ability to execute a statement against it.

Regards,|||I can't execute a query because I get the error above, but I can not only see the table in the left panel of SQL Management Studio Express but can also display the table's data by right clicking on it and selecting "Open Table".|||OK. Something is not right here.

From what you say above, this is in no a security issue. When you right click on a table and click 'Open Table', the underlying event will just execute a SELECT statement against the table.

Therefore, you should be able to execute:

select * from tblTXMup

If you still receive the same message, try the following and let me know what the result is.

select
*
from
information_schema.tables
wehre
table_name = 'tblTXMup'

Regards,|||Robert,

Thanks again for helping. After running your query I got what looked like five column headers as follows: blank, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE

What does that tell us?|||What was the output returned for each query?

For the first, did you receive an error message, an empty result set, or a set of rows? And similarly for the second, did you receive a single row describing the table,or did you just receive the column headers, but no rows?

Regards,|||Thanks, Robert. From the first, that is the one that I started this thread with, and it still throws the same error. In the second, I got no error, did get headers, got no rows. The headers act like buttons that "depress" when clicked on.|||Could you please try to create the table under the same login account that from which you ran the above queries. At this stage, we wish to examine ownership configurations for the table and the databases that your account is accessing.

What may be happening is that you have two sessions open, each accessing a different database. Your first session may display the 'Welcome Page' to SQL Server 2005 management studio. When you browse the object tree, you select the appropriate database and then browse the object. Having selected 'DatabaseA' from the Object List, you see the results that you had expected.

On the other hand your second session (which appears as a new tab) has opened to an SQL Query interface, but the session is connected to a different database by default. This may well be the Master database. Consequently when you run the select query against the master database, SQL Server reports that your table does not exist.

You may just want to check which database your SQL Query interface session is connected to, and ensure that this is indeed the database that contains the table you wish to query. If this session appears to be accessing the correct database, then you can create a simple table from this session with the same name as the one you are trying to query, and note the outcome.

Once you have created this table, check to see that it appears in the database you expected it to, in the Object Browser. Once you have found it, compare this location to that of the original table that you mentioned in you first post, against which you were able to right click and select 'Open Table'.

The following code will create a simple one column table.

create table tblTXMup (id int);

Regards,|||Has it got anything to do with 3 part naming?
Objects that aren't given a 2nd part are assumed to be owned by "dbo"
i.e.

SELECT * FROM myTable
--equivalent to
SELECT * FROM dbo.myTable

Try running the following and let me know if you get any results

SELECT *
FROM sysobjects
WHERE type IN ('U', 'V')
AND name LIKE '%tblTXMup%'|||George, I ran your query and got a number of column headings but no rows returned. Headings started off name, id, xtype, uid, ...

Does that tell us anything?

Thanks for helping.|||Loyd,

Have you performed the steps that I mentioned in my most recent post? They are designed such that by the end, you should almost certainly know the answer to your problem.

The essence of the problem is this: We need to identify the a) where the table is, b) which account owns it, and most importantly, c) which account you are connected as when you are running these queries that we have supplied.|||OK, so you can open the table via enterprise manager, but can not get to it in Query Analyzer. That sums up the problem? From the results of the queries above, I suspect the two tools are looking at different databases. Run this query to see what database you are currently in in Query Analyzer:

select db_name()

Do you get the expected result?|||r123456 and MCrowley you are both on to something. When I created the table it appeared in the master system db. How can I move to or attach to the correct db?|||Exactly what I thought. You had two sessions open, each pointing to different databases.

I would attach a screen shot to explain, but I don't have SQL Server Management Studio installed. There is a drop down list on the tool bar, just above the query windows, which contains the list of databases that you're account has access to. The database name that appears selected in this list, is the one that all statements in the current session will be executed against, unless of course you explicitly define the database name in the query, which evidently you have not done on this occasion.

Once you've selected the session in which you want to run the SQL Query (not the one you used to browse the Object Tree), ensure that the value in this drop down list is the one for which you want your query to be executed against.

Regards,|||One note, putting user tables in the master database is generally a bad thing. Recovering the master database from backup requires a series of steps that include stopping and restarting the whole server several times. This gets to be annoying to anyone else who happens to be using the server at the time. I would suggest either redoing the upgrade to a user database (you can create one through Enterprise Manager easily enough), or exporting the data from master to a user database. The choice will depend on how many foreign keys you have created in there.|||Ah yes. I will second that suggestion. The number of times I have gone to execute a query, only to notice that the database is pointing to Master.

Another suggestion is to create administrator accounts that are a step down in terms of access rights from the DBO account. This is common practice in most organisations as it achieves two major benefits. Firstly, you have accountability for all access to the database if you configure access to SQL Server to be through Windows NT accounts. Secondly, you can ensure that users only have access to the databases that is permitted by your firm's access policy.

Regards,|||Thanks once more for all the assistance. I am finding out what a newbie I am with SQL Server. I have been submitting SQL queries to SQL Server for years, but have not had a great deal of experience with administering it.

I can submit a query by specifying the database, but the dropdown where I could specify a database to connect to is grayed out and I can't access it. What can I do in SQL Server Management Studio Express to get access to that dropdown?

BTW, as far as permissions, I am working on SQL Server on my own development machine, trying to get all the queries working before uploading to the host development site.

Thanks again|||Thanks once more for all the assistance. I am finding out what a newbie I am with SQL Server. I have been submitting SQL queries to SQL Server for years, but have not had a great deal of experience with administering it.

I can submit a query by specifying the database, but the dropdown where I could specify a database to connect to is grayed out and I can't access it. What can I do in SQL Server Management Studio Express to get access to that dropdown?

BTW, as far as permissions, I am working on SQL Server on my own development machine, trying to get all the queries working before uploading to the host development site.

Thanks again

Loyd,

You will need to ensure that you have the set the focus on an SQL Server query session, for it is these sessions that the drop down list applies to. When you want to access the Database name drop down list, first click anywhere in the session window (example: the window where you type the SQL queries) and then the drop down list become available.

It is unlikely that there are other reasons for the drop down list not being available for you to access.

Regards,

Can't Run Query Analyzer

When trying to access Query Analyzer from Enterprise Manager, I receive the
error, "The specified file was not found". I don't know what happened, as it
was working fine yesterday, and I've made no changes to the system in the
interim. SQL Server 2000 Standard Edition running under Win 2003 Server, sp1.
Any immediate thoughts would be welcome.Hi
You may want to check out http://tinyurl.com/85xwc, you could re-add it as
an external tool or re-install the client tools should fix it.
John
"Mike Kelly" <Mike Kelly@.discussions.microsoft.com> wrote in message
news:D0FE4485-A324-44C3-B4EC-59E996B84987@.microsoft.com...
> When trying to access Query Analyzer from Enterprise Manager, I receive
> the
> error, "The specified file was not found". I don't know what happened, as
> it
> was working fine yesterday, and I've made no changes to the system in the
> interim. SQL Server 2000 Standard Edition running under Win 2003 Server,
> sp1.
> Any immediate thoughts would be welcome.

Can't Run Query Analyzer

When trying to access Query Analyzer from Enterprise Manager, I receive the
error, "The specified file was not found". I don't know what happened, as it
was working fine yesterday, and I've made no changes to the system in the
interim. SQL Server 2000 Standard Edition running under Win 2003 Server, sp1
.
Any immediate thoughts would be welcome.Hi
You may want to check out http://tinyurl.com/85xwc, you could re-add it as
an external tool or re-install the client tools should fix it.
John
"Mike Kelly" <Mike Kelly@.discussions.microsoft.com> wrote in message
news:D0FE4485-A324-44C3-B4EC-59E996B84987@.microsoft.com...
> When trying to access Query Analyzer from Enterprise Manager, I receive
> the
> error, "The specified file was not found". I don't know what happened, as
> it
> was working fine yesterday, and I've made no changes to the system in the
> interim. SQL Server 2000 Standard Edition running under Win 2003 Server,
> sp1.
> Any immediate thoughts would be welcome.

Can't Run Query Analyzer

When trying to access Query Analyzer from Enterprise Manager, I receive the
error, "The specified file was not found". I don't know what happened, as it
was working fine yesterday, and I've made no changes to the system in the
interim. SQL Server 2000 Standard Edition running under Win 2003 Server, sp1.
Any immediate thoughts would be welcome.
Hi
You may want to check out http://tinyurl.com/85xwc, you could re-add it as
an external tool or re-install the client tools should fix it.
John
"Mike Kelly" <Mike Kelly@.discussions.microsoft.com> wrote in message
news:D0FE4485-A324-44C3-B4EC-59E996B84987@.microsoft.com...
> When trying to access Query Analyzer from Enterprise Manager, I receive
> the
> error, "The specified file was not found". I don't know what happened, as
> it
> was working fine yesterday, and I've made no changes to the system in the
> interim. SQL Server 2000 Standard Edition running under Win 2003 Server,
> sp1.
> Any immediate thoughts would be welcome.

can't run dta

I had installed a new sql server 2005 enterprise with windows server 2003 enterprise,all done,but when I click the connect button to conect ,I get the error " Could not find stored procedure 'msdb..sp_DTA_help_session'".

Please see the following link that describes the permissions required for running DTA.

http://msdn2.microsoft.com/en-us/library/ms186330.aspx

cant restore database from .a .bak file in enterprise manager

Hi Everybody,

I use MS SQL server 2000 enterprise manager on a windows server 2003.

I created a new database in enterprise manager, and try to restore the new database from a .bak file.
I went to -->restore database. I checked"from device"and select the right path to the .bak file.
Then I click ok, but there is anerrorpop up."tend to override existing database",
so I went to -->option, and checked"force override existing database". then I click ok, but get an error look like this http://ewwa.lo7.net/error.JPG

I thought it was a problem with my .bak file. So I try to use another .bak file which I am sure it is 100% good. It prompt the restore issucessfully. But when I checked the db, therenothing there(No tables).

I think there must be something wrong with my enterprise manager's configuration.

Do you know what happen with my enterprise manager? Thank you a lot in advance:)!!

barbarallama:

Hi Everybody,

I use MS SQL server 2000 enterprise manager on a windows server 2003.

I created a new database in enterprise manager, and try to restore the new database from a .bak file.
I went to -->restore database. I checked"from device"and select the right path to the .bak file.
Then I click ok, but there is anerrorpop up."tend to override existing database",
so I went to -->option, and checked"force override existing database". then I click ok, but get an error look like this http://ewwa.lo7.net/error.JPG

You tried to create a new database by restoring from a .bak file, right? Then there are some tips you may know:

1. Specify a database name that differs from existing databases for the new database, then the restore will create a new database rather than attemping to override existing database.

2. In the Options tab, make sure all values in the 'Move to physical file name' column point to a valid file path. If any path dose not exist, an error likeshttp://ewwa.lo7.net/error.JPG will be raised.

barbarallama:

I thought it was a problem with my .bak file. So I try to use another .bak file which I am sure it is 100% good. It prompt the restore issucessfully. But when I checked the db, therenothing there(No tables).

Not sure why this happened. Can you perform queries on the database? If yes, login as 'sa' and perform a query like this :

select * from sysobjects where xtype <>'S'

|||Hi Lori,
That is really helpful, the problem is the path is invalid. Thanks A Lot!

Can't Register SQLServer in Enterprise Manager

I have been trying to register a SQL server in my server
group in Enterprise Manager but it cannot find the
server. The SQL server (SQLServer2k) resides on a server
machine running WinServer2K. I am trying to gain access
from a remote PC running Win2k.
I am able to see the server in the list of available
servers when I run the registration wizard. But when I
finish the wizard it fails to establish a connection. I
have double checked login ID and password. I even set up
another instance of a SQL server on the server machine.
When I start the wizard again to register the new server,
I see the new server in the available list but I can't
connect to it either.
I uninstalled and reinstalled SQLServer2k on both the
server and the client PC. Still no luck. I can establish
ethernet connection between the two machines so it doesn't
appear to be a network problem, especially when I can see
the servers in my availability list.
Any ideas on why this is happening and how to fix?
Roger.
We had some issues in our group, where the default database specified in the
Login was no longer attached to the SQL Server.
This caused the Server Registration to fail.
HTH, Amol.
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:92c101c43367$84ec1910$a501280a@.phx.gbl...
> I have been trying to register a SQL server in my server
> group in Enterprise Manager but it cannot find the
> server. The SQL server (SQLServer2k) resides on a server
> machine running WinServer2K. I am trying to gain access
> from a remote PC running Win2k.
> I am able to see the server in the list of available
> servers when I run the registration wizard. But when I
> finish the wizard it fails to establish a connection. I
> have double checked login ID and password. I even set up
> another instance of a SQL server on the server machine.
> When I start the wizard again to register the new server,
> I see the new server in the available list but I can't
> connect to it either.
> I uninstalled and reinstalled SQLServer2k on both the
> server and the client PC. Still no luck. I can establish
> ethernet connection between the two machines so it doesn't
> appear to be a network problem, especially when I can see
> the servers in my availability list.
> Any ideas on why this is happening and how to fix?
> Roger.
>

Can't Register SQLServer in Enterprise Manager

I have been trying to register a SQL server in my server
group in Enterprise Manager but it cannot find the
server. The SQL server (SQLServer2k) resides on a server
machine running WinServer2K. I am trying to gain access
from a remote PC running Win2k.
I am able to see the server in the list of available
servers when I run the registration wizard. But when I
finish the wizard it fails to establish a connection. I
have double checked login ID and password. I even set up
another instance of a SQL server on the server machine.
When I start the wizard again to register the new server,
I see the new server in the available list but I can't
connect to it either.
I uninstalled and reinstalled SQLServer2k on both the
server and the client PC. Still no luck. I can establish
ethernet connection between the two machines so it doesn't
appear to be a network problem, especially when I can see
the servers in my availability list.
Any ideas on why this is happening and how to fix?
Roger.We had some issues in our group, where the default database specified in the
Login was no longer attached to the SQL Server.
This caused the Server Registration to fail.
HTH, Amol.
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:92c101c43367$84ec1910$a501280a@.phx.gbl...
> I have been trying to register a SQL server in my server
> group in Enterprise Manager but it cannot find the
> server. The SQL server (SQLServer2k) resides on a server
> machine running WinServer2K. I am trying to gain access
> from a remote PC running Win2k.
> I am able to see the server in the list of available
> servers when I run the registration wizard. But when I
> finish the wizard it fails to establish a connection. I
> have double checked login ID and password. I even set up
> another instance of a SQL server on the server machine.
> When I start the wizard again to register the new server,
> I see the new server in the available list but I can't
> connect to it either.
> I uninstalled and reinstalled SQLServer2k on both the
> server and the client PC. Still no luck. I can establish
> ethernet connection between the two machines so it doesn't
> appear to be a network problem, especially when I can see
> the servers in my availability list.
> Any ideas on why this is happening and how to fix?
> Roger.
>

Can't Register SQL server in EM

I have been trying to register a SQL server in my server
group in Enterprise Manager but it cannot find the
server. The SQL server (SQLServer2k) resides on a server
machine running WinServer2K. I am trying to gain access
from a remote PC running Win2k.
I am able to see the server in the list of available
servers when I run the registration wizard. But when I
finish the wizard it fails to establish a connection. I
have double checked login ID and password. I even set up
another instance of a SQL server on the server machine.
When I start the wizard again to register the new server,
I see the new server in the available list but I can't
connect to it either.
I uninstalled and reinstalled SQLServer2k on both the
server and the client PC. Still no luck. I can establish
ethernet connection between the two machines so it doesn't
appear to be a network problem, especially when I can see
the servers in my availability list.
Any ideas on why this is happening?
Roger.
What error are you getting when the connection failure occurs?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I get a simple "Timeout expired" message. (in detail: "<servername> - Timeout expired")
Roger.
-- Rand Boyd [MSFT] wrote: --
What error are you getting when the connection failure occurs?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Try increasing the login timeout for Enterprise Manager. In
Enterprise Manager, go to the menu to tools and then select
Options. On the Advanced tab, increase the login timeout
from the default 4 seconds.
-Sue
On Fri, 7 May 2004 09:16:04 -0700, "Roger Denison"
<anonymous@.discussions.microsoft.com> wrote:

>I get a simple "Timeout expired" message. (in detail: "<servername> - Timeout expired")
>Roger.
> -- Rand Boyd [MSFT] wrote: --
> What error are you getting when the connection failure occurs?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||set the login time out to 0 which is unlimited
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:Mw9dC72MEHA.3780@.cpmsftngxa10.phx.gbl...
> What error are you getting when the connection failure occurs?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>