[Venting]

So I have this box with SQL Server 2000, Evaluation edition of SQL 2005
which has top be installed as a named instance because of the way that 2K &
2K5 co-exist on the same box, and then there are a couple silly apps I have
that install MSDE as other named instances.
and the STUPI .NET DATA CONNECTION DIALOG doesn't have a field geared toward
named instances.
@.#$%^&
I will now crawl back under my rock.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSenseiCan you edit the connection string in web.config or the source code?
"Mike Labosh" <mlabosh_at_vbsensei_dot_com> wrote in message
news:uwZSfc5PGHA.4900@.TK2MSFTNGP09.phx.gbl...
> So I have this box with SQL Server 2000, Evaluation edition of SQL 2005
> which has top be installed as a named instance because of the way that 2K
> &
> 2K5 co-exist on the same box, and then there are a couple silly apps I
> have
> that install MSDE as other named instances.
> and the STUPI .NET DATA CONNECTION DIALOG doesn't have a field geared
> toward
> named instances.
> @.#$%^&
> I will now crawl back under my rock.
>
> --
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>|||> Can you edit the connection string in web.config or the source code?
2K
Of course I can. It just angers me that the silly little foolish dialog
doesn't let me say so.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei

[SQLSTATE 42000] (Error 22029).

We have SQL Server 2000 installed on Windows 2003
machine. Get following error while doing database
maintenance
Executed as user: server\sqladmin. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.
SQL Server log doesn't say anything either.
Any idea on what could be wrong? Thanks.
You need to look at the maintenance plan history or the report file for that
job to find the error.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"anonymous" <anonymous@.discussions.microsoft.com> wrote in message
news:885c01c48531$710fd050$a601280a@.phx.gbl...
> We have SQL Server 2000 installed on Windows 2003
> machine. Get following error while doing database
> maintenance
> Executed as user: server\sqladmin. sqlmaint.exe failed.
> [SQLSTATE 42000] (Error 22029). The step failed.
> SQL Server log doesn't say anything either.
> Any idea on what could be wrong? Thanks.

[SQL2005] equivalent to the SQL 2000 taskpad view in Management St

Hello,
I just installed SQL 2005, and I am looking for the information about my
file usage, as I was able to see in the taskpad view with SQL 2000.
Could you help me on this please ?
Thanks in advance,
Regards,
Vincent
Hello Vincent,
There is no Taskpad in SQL Server 2005. There are Reports instead.
Go to a database and right click on it. You'll see Reports\Standard
Reports\Disk Usage.
I know this looks slower and do not have other stuff (tasks) in it, however
this is the new thing instead of Taskpad in SQL Server 2005.
Ekrem ?nsoy
"Vincent D." <VincentD@.discussions.microsoft.com> wrote in message
news:313F2B87-34F4-4A2F-9DB4-E268DC4B4424@.microsoft.com...
> Hello,
> I just installed SQL 2005, and I am looking for the information about my
> file usage, as I was able to see in the taskpad view with SQL 2000.
> Could you help me on this please ?
> Thanks in advance,
> Regards,
> Vincent
|||Hello Ekrem,
Thanks for your help.
My problem is that I have a Siebel database, and I cannot use the 9.0 mode,
I must stay in 8.0 mode. And in 8, I can't see the Disk Usage Report
Do you know any workarround ?
Thanks in advance,
Regards,
Vincent
"Ekrem ?nsoy" wrote:

> Hello Vincent,
> There is no Taskpad in SQL Server 2005. There are Reports instead.
> Go to a database and right click on it. You'll see Reports\Standard
> Reports\Disk Usage.
> I know this looks slower and do not have other stuff (tasks) in it, however
> this is the new thing instead of Taskpad in SQL Server 2005.
> --
> Ekrem ?nsoy
>
> "Vincent D." <VincentD@.discussions.microsoft.com> wrote in message
> news:313F2B87-34F4-4A2F-9DB4-E268DC4B4424@.microsoft.com...
>
|||Well, nope for the Reports, sorry. However you can use sp_spaceused sp to
see space info about your db.
Also, you can see the space info from the database properties.
Ekrem ?nsoy
"Vincent D." <VincentD@.discussions.microsoft.com> wrote in message
news:3E011161-4597-4F78-94A6-15FBA9E7A9CC@.microsoft.com...[vbcol=seagreen]
> Hello Ekrem,
> Thanks for your help.
> My problem is that I have a Siebel database, and I cannot use the 9.0
> mode,
> I must stay in 8.0 mode. And in 8, I can't see the Disk Usage Report
> Do you know any workarround ?
> Thanks in advance,
> Regards,
> Vincent
> "Ekrem ?nsoy" wrote:
|||Hello Ekrem,
I have SQL Server 2005 sp2 and my database is in 9.0 mode. On right
click I don't see Reports. I do see reports on Summary window. What is
a difference between standard reports and performance dashboards. I
now that for performance dashboards you need to have a SP2 on your
server and I sow that some servers without sp2 have reports on the
Summary window.
Ognjen
Ekrem nsoy wrote:[vbcol=seagreen]
> Hello Vincent,
> There is no Taskpad in SQL Server 2005. There are Reports instead.
> Go to a database and right click on it. You'll see Reports\Standard
> Reports\Disk Usage.
> I know this looks slower and do not have other stuff (tasks) in it, however
> this is the new thing instead of Taskpad in SQL Server 2005.
> --
> Ekrem nsoy
>
> "Vincent D." <VincentD@.discussions.microsoft.com> wrote in message
> news:313F2B87-34F4-4A2F-9DB4-E268DC4B4424@.microsoft.com...
|||Hello!
There is no Reports in SQL Server Management Studio Express.
You must be using SSMSE to connect to your SQL Server instances so you can't
see Reports when you right click on your databases. You need SSMS to see
Reports menu when you right click on a database.
I encourage you to see the following link to learn more about Performance
Dashboard Reports:
http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
Ekrem nsoy
"OgnjenT" <OgnjenT@.gmail.com> wrote in message
news:e6c35d61-2ee9-4b76-9286-dbb9e5f83ac2@.i12g2000prf.googlegroups.com...
Hello Ekrem,
I have SQL Server 2005 sp2 and my database is in 9.0 mode. On right
click I don't see Reports. I do see reports on Summary window. What is
a difference between standard reports and performance dashboards. I
now that for performance dashboards you need to have a SP2 on your
server and I sow that some servers without sp2 have reports on the
Summary window.
Ognjen
Ekrem nsoy wrote:[vbcol=seagreen]
> Hello Vincent,
> There is no Taskpad in SQL Server 2005. There are Reports instead.
> Go to a database and right click on it. You'll see Reports\Standard
> Reports\Disk Usage.
> I know this looks slower and do not have other stuff (tasks) in it,
> however
> this is the new thing instead of Taskpad in SQL Server 2005.
> --
> Ekrem nsoy
>
> "Vincent D." <VincentD@.discussions.microsoft.com> wrote in message
> news:313F2B87-34F4-4A2F-9DB4-E268DC4B4424@.microsoft.com...
|||Hopefully, Siebel finally validated the usage of the 9.0 mode ! I'm saved
;-)
"Ekrem ?nsoy" wrote:

> Well, nope for the Reports, sorry. However you can use sp_spaceused sp to
> see space info about your db.
> Also, you can see the space info from the database properties.
> --
> Ekrem ?nsoy
>
> "Vincent D." <VincentD@.discussions.microsoft.com> wrote in message
> news:3E011161-4597-4F78-94A6-15FBA9E7A9CC@.microsoft.com...
>
|||Hello,
I am using Sql Server 2005 developer edition and I am not using SSMSE
but SSMS.
Ekrem ?nsoy wrote:[vbcol=seagreen]
> Hello!
> There is no Reports in SQL Server Management Studio Express.
> You must be using SSMSE to connect to your SQL Server instances so you can't
> see Reports when you right click on your databases. You need SSMS to see
> Reports menu when you right click on a database.
> I encourage you to see the following link to learn more about Performance
> Dashboard Reports:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
> --
> Ekrem ?nsoy
>
> "OgnjenT" <OgnjenT@.gmail.com> wrote in message
> news:e6c35d61-2ee9-4b76-9286-dbb9e5f83ac2@.i12g2000prf.googlegroups.com...
> Hello Ekrem,
> I have SQL Server 2005 sp2 and my database is in 9.0 mode. On right
> click I don't see Reports. I do see reports on Summary window. What is
> a difference between standard reports and performance dashboards. I
> now that for performance dashboards you need to have a SP2 on your
> server and I sow that some servers without sp2 have reports on the
> Summary window.
> Ognjen
> Ekrem ?nsoy wrote:
|||I don't have the RTM version of SSMS on my test machines so I can't be sure
of that... Did you apply SP2 to your Client Tools (which includes SSMS)?
Ekrem ?nsoy
"OgnjenT" <OgnjenT@.gmail.com> wrote in message
news:9957500e-940d-46fb-8d2a-f549e243aa51@.r29g2000hsg.googlegroups.com...
Hello,
I am using Sql Server 2005 developer edition and I am not using SSMSE
but SSMS.
Ekrem ?nsoy wrote:[vbcol=seagreen]
> Hello!
> There is no Reports in SQL Server Management Studio Express.
> You must be using SSMSE to connect to your SQL Server instances so you
> can't
> see Reports when you right click on your databases. You need SSMS to see
> Reports menu when you right click on a database.
> I encourage you to see the following link to learn more about Performance
> Dashboard Reports:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
> --
> Ekrem ?nsoy
>
> "OgnjenT" <OgnjenT@.gmail.com> wrote in message
> news:e6c35d61-2ee9-4b76-9286-dbb9e5f83ac2@.i12g2000prf.googlegroups.com...
> Hello Ekrem,
> I have SQL Server 2005 sp2 and my database is in 9.0 mode. On right
> click I don't see Reports. I do see reports on Summary window. What is
> a difference between standard reports and performance dashboards. I
> now that for performance dashboards you need to have a SP2 on your
> server and I sow that some servers without sp2 have reports on the
> Summary window.
> Ognjen
> Ekrem ?nsoy wrote:

[S0001][unixODBC][Easysoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test1'

Hello,

I am new to SQL Server, sorry for my ignorance !!!

I have installed SQL Server 2005 Express on my desktop (Win 2000 Pro.)

I have created a new database.

I just created a new login/user (SQL Authentication) and when I try to login, it

errors out:

[S0001][unixODBC][Easysoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test1'

I believe the error is from SQL Server and not from ODBC driver.

I am also only able to connect by using my own userid (the one that I am connected to my desktop): domain\userid, and then I am only able to connect to 'master' db:

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

/usr/local/etc>isql SQLSERVER_POS -v
++
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
++
SQL> use pcspos
[S0001][unixODBC][Easysoft][ODBC SQL Server Driver][SQL Server]Could not locate entry in sysdatabases for database 'pcspos'. No entry found with that name. Make sure that the name is entered correctly.
[ISQL]ERROR: Could not SQLExecute
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Hello,

While I browse the SSMSE (SQL Server Management Studion Express) , I see that the database state (from the

Database Properties Windows) is NORMAL | SHUTDOWN !!!!!!

Is this OK ?

In the meantime when I login via SSMSE, I can see all the tables and data in the database !!!!!!!!!

Thanks,

Tom

|||

Hello, I was able to change the Database State to NORMAL (I changed the 'Auto Close' option to False).

BUT I am still not able to connect:

/usr/local/etc>isql SQLSERVER_POS -v
[S0001][unixODBC][Easysoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test1'.
[ISQL]ERROR: Could not SQLConnect

|||If you are using Windows Authentication only, you cannot use SQL Server logins to connect to the server. (see how to switch the authentication mode on my website under the Screencasts). If you want to use WIndows authentication you will have to be aware that you cannot explicitly pass a user name within the connectionstring, the username is passed implicitly through Windows. If you have enabled Mixed authentication already, make sure that you are using the right password.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens, thank you for your reply.

I am using the SQL Authentication mode, see below I am able to connect from the DOS prompt (localy),

but I can NOT connect from a Linux server by using the ODBC driver:

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

C:\>isql -S (local)\SQLEXPRESS -U pos_sql05 -P passwd
1> select db_name()
2> go

--

--

--
POS

(1 row affected)
1> select * from pcs_lookup_active_status;
2> go
ACTIVE_STATUS_KEY ACTIVE_STATUS_DESC
-- --
1 Active
2 Inactive
3 Deleted

(3 rows affected)

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

|||I don′t know how the tool for Linux works but if you do not pass a username using SQL Server authentication there has to be somewhere a setting file where these information is stored.
|||

I am using a config file by the name odbc.ini.

It looks like the following:

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

[SQLSERVER_POS]
Driver = /usr/local/easysoft/sqlserver/lib/libessqlsrv.so
Description = Easysoft SQL Server ODBC driver (unixODBC 2.2.12)
Server = 10.20.30.40\SQLEXPRESS
Port = 1433
Database = POS
User = pos_sql05
Password = passwd
Mars_Connection = No
Logging = 31
LogFile = /tmp/sqlserver.log
QuotedId = Yes
AnsiNPW = Yes
Language =
Version7 = No
ClientLB = No
Failover_Partner =
VarMaxAsLong = No

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

As you cann tell, the user id and password are there.

Thanks again.

Regards,

Tom

|||

Make sure that you are using the right password for the mentioned user. In addition make sure taht the user is priviledged for the POS database, cause authentication or the connection will also fail if the initial database is not one of the allowed ones. if you are not sure, try to connect to the master database. A user which is granted access to the server should have access to the master database.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens, thanks again.

The userid and password are correct (I am able to connect via isql from the DOS prompt).

I think the problem relies on the fact that I am coming remotetly (from a Linux server), BUT I have

enabled the TCP/IP protocol connection properties. What else can I look for ?

Thank you.

Tom

|||

How are you authenticating? Is your server set to authenticate using Windows authentication only or integrated authentication? Perhaps this unix driver is trying to use SQL authentication and your SQL installation only accepts windows authenticated connections. That would explain this problem.

Hope this helps!

John (MSFT)

|||

Hi John & Jens, the issue has been resolved. I contacted the ODBC driver's vendor and they provided me with an updated copy of it.

Thank you for your help and suggestions.

Keep up the GREAT job.

Best regards,

Tom

[news] free copy of SQL Prompt

so last week i finally downloaded and installed SQL Server 2005, and along with that, i downloaded Studio Express (i had previoulsy been using MSDE with WinSQL by Synametrics)

anyhow, today i got an alert from google (you guys use those, right?) that there's a free copy of something called SQL Prompt available from Red Gate

i tried it, and i like it!!

see http://builder.com.com/5100-6388_14-6085249.html?part=rss&subj=bldrEDIT - Coo - my first post did stick|||anyhow, today i got an alert from google (you guys use those, right?) that there's a free copy of something called SQL Prompt available from Red Gate

i tried it, and i like it!!Harrumph. I paid $25 USD for my copy before Red Gate bought the product. So long as they keep developing it though (doesn't pick up functions, can't handle subqueries and derived tables etc yet) then I am happy :)

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name

I have a ms sqlserver 2000 database installed on my Windows NT4 PC.

I want to access this database from a java program using JDBC - ODBC

Here are the relavent lines of code from my java source code file.

Note : I am attempting to access the sample database "Northwind Traders" that came with the installation.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
datasource = "NORTHDS";
url = "jdbc:odbc:" + datasource;
con = DriverManager.getConnection(url,username,password) ;
query = "SELECT * from " + datasource + "." + username + "." + tablename;
ResultSet rs = stmt.executeQuery(query);

The connection succeeds but the query fails with :
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object name 'NORTHDS.username.Customers'.

Using the program "Microsoft Access" I was able to verify that the "Customers" table is intact.

Any ideas ?Take a look at the following:

In your select statement there are a couple of potential problems that you need to verify.

select * from datasource.username.table ... which is returning 'NORTHDS.username.Customers'

should be

select * from Northwind.dbo.Customers ... (unless you renamed the database ...)

In other words, check to make sure your are referencing the correct database/owner/table in your select statement. It appears that the variables you are using are incorrect. tablename appears to be ok, but the username variable is returning username. Also, the datasource variable may not be your database name.

[Microsoft][ODBC SQL Server Driver] Timeout Expired

Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro PC. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount of data it works.
Could you please help me with that?
Thanks
DJ
hi
goto the server properties.then there is a property called connection time.
check it and give the appropiate time on this

[Microsoft][ODBC SQL Server Driver] Timeout Expired

Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount of data it works.

:confused:

Could you please help me with that?
Thanks
DJCheck out this page.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;313661|||The link in the previous post is for a connection timeout using SQL Server 7. It does not apply to running a query on SQL Server 2000.|||SQL Server 2000's default timeout period it 600 seconds (10 minutes). If you change it to zero (0), that's infinite. How long is it taking to timeout?

If you run a long query through the Enterprise Manager, it will timeout after 30 seconds. MS's answer to this is to use the Query Analyzer (which should not timeout). I've run a 14-hour query through SQL Query Analyzer before.

[Microsoft][ODBC SQL Server Driver] Timeout Expired

Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro PC. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount of data it works.
Could you please help me with that?
Thanks
DJhi
goto the server properties.then there is a property called connection time
.
check it and give the appropiate time on this

[help]:SQLServer 2000 setup fails!

Dear All:
I receive the error with _INS5576._MP.exe when i installed sqlserver 2000
pls help me to solve this problem
ThanksWhat is the version of MSSQL server you tried to install?
What is your operating system?
Can you post the error message you got?|||Originally posted by gyuan
What is the version of MSSQL server you tried to install?
What is your operating system?
Can you post the error message you got?

i wanna to install STANDARD version in my windows 2000 server
I receive the error with "application error in _INS5576._MP "

pls help me ,thanks|||In which step did you get the error message?|||Originally posted by gyuan
In which step did you get the error message?

The first step,i click the SETUPSQL.EXE|||What is the Service Pack on your windows 2000 server? When you tried to install the MSSQL server did you close any other applications?|||Did you log on windows using Administrator account?|||Originally posted by gyuan
What is the Service Pack on your windows 2000 server? When you tried to install the MSSQL server did you close any other applications?

I've installed sp3 ,i have closed any other applictions when i install the sqlserver and i use administrator installed it|||Is is solved ? If not, read the following link:

link (http://dbforums.com/arch/175/2002/3/331731)

Also, check your installation log files for more information- sqlstp.log, sqlsp.log, and setup.iss.|||Originally posted by rnealejr
Is is solved ? If not, read the following link:

link (http://dbforums.com/arch/175/2002/3/331731)

Also, check your installation log files for more information- sqlstp.log, sqlsp.log, and setup.iss.

but i didn't find ActiveSync in my computer

can you tell me where is the sqlstp.log ,sqlsp.log,and setup.iss?|||Originally posted by board
but i didn't find ActiveSync in my computer

can you tell me where is the sqlstp.log ,sqlsp.log,and setup.iss?

here is the sqlstp.log

15:23:58 Begin Setup
15:24:28 ?ɡ

15:24:28 End Action: Locked Connectivity Files Check
15:24:28 ??? Microsoft ? (MDAC) ...
15:24:28 D:\NET\SQLSER~1\ENTERP~1\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
15:24:43 ExitCode: 0
15:24:43 ??? Microsoft ??_ (MSDTC) ...
15:24:43 C:\WINNT\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir "C:\WINNT\TEMP\SqlSetup\Bin" -DTCPkg "D:\NET\SQLSER~1\ENTERP~1\x86\Other\dtcsetup.exe" -LogFile "C:\WINNT\sqlstp.log"
15:24:43 Process Exit Code: (0)
15:24:43 InstallMSSearch instance: MSSQLSERVER
15:24:43 Software\Microsoft\Search\Install:Version : 9.107.5512
15:24:43 MSSearch 2.0 or greater version check returned 1
15:24:43 ??? Microsoft ??...
15:24:43 "D:\NET\SQLSER~1\ENTERP~1\x86\FullText\MSSearch\Sea rch\SearchStp.exe" /s /a:SQLServer
15:24:52 Process Exit Code: (0)
15:24:52 /Q:A /T:C:\WINNT\TEMP\ixp001.tmp
15:24:52 ??? HTML
15:24:52 HTML Help installer exit code: 0
15:25:14 End Action InstallPkgs
15:25:14 Begin Action MoveFileData:
15:25:14 Enabled SELFREGISTERBATCH
15:25:14 Enabled CORECOMPONENTHANDLING
15:25:47 Begin Action: MoveFileDataSpecial
15:25:47 End Action: MoveFileDataSpecial
15:25:47 End Action MoveFileData
15:25:47 Begin Action ProcessAfterDataMove:
15:25:47 D:\NET\SQLSER~1\ENTERP~1\x86\Binn\hhcol.exe C:\Program Files\Microsoft SQL Server\80\Tools\Books
15:25:49 End Action ProcessAfterDataMove
15:25:49 Begin Action BuildServer:
15:25:49 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
15:25:49 Process Exit Code: (0)
15:25:49 Begin Action: CreateRegistrySetSQL
15:25:49 End Action: CreateRegistrySetSQL
15:25:49 Begin Action: RegWriteSetupEntry
15:25:49 End Action: RegWriteSetupEntry
15:25:49 Begin Action: CreateSer
15:25:49 End Action: CreateSer
15:25:49 Begin Action: SkuIt
15:25:50 End Action: SkuIt
15:25:50 SetFileSecuritySQLAndAdmin for d:\Program Files\Microsoft SQL Server\MSSQL returned: 1350, 1350
15:25:50 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL Server\MSSQL returned: 1350, 1350
15:25:50 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
15:25:50 Begin Action: UpdateSystemPath
15:25:50 Path successfully updated.
15:25:50 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
15:25:50 End Action: UpdateSystemPath
15:25:51 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Chinese_PRC_CI_AS" -H 1179808 -U sa -P
################################################## #############################

?

Chinese_PRC_CI_AS

-m -Q -T4022 -T3659

?

driver={sql server};server=google15;UID=sa;PWD=;database=maste r

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=google15;UID=sa;PWD=;database=maste r

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=google15;UID=sa;PWD=;database=maste r

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

SQL Server ?

################################################## #############################

15:28:02 Process Exit Code: (-1)|||It looks like it is failing when configuring the server. Please post the output from cnfgsvr.out.|||Also, what is the translation on these 2 lines:

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

SQL Server ?|||Originally posted by rnealejr
Also, what is the translation on these 2 lines:

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server ??

SQL Server ?

The problem had solved , I installed the sp4 for my windows 2000 server
It's ok now!

Thanks

[Fail] Could not add ASPNET user to SQL Server.

Ok here's my setup

1. Installed msde 2000 with sp3.
2. started the SQL Server and SQL Server Agent.
3. Ran IBuySpy Store Installation, when I ran the configuration I get error on bottum.

10:51:55 PM Tuesday, September 23, 2003: [Checking system requirements]
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected a local instance of SQL Server.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected .NET Framework.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected Internet Information Server (IIS).
10:52:03 PM Tuesday, September 23, 2003: [Begin Sample Configuration]
10:52:05 PM Tuesday, September 23, 2003: [Pass] Created IIS virtual directory.: StoreVBVS
10:52:05 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:52:22 PM Tuesday, September 23, 2003: [Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
10:52:22 PM Tuesday, September 23, 2003: [Done]

Can someone please tell me step by step on what I need to do and where to do it to get this working, thanks !!!did you add it via users in your db? when you xpand our db in sql server xplorer, you can add users using "users"...

HTH

[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied

ok im a CS student, installed visual studio .net, and im trying to connect to a ms sql database (Northwind), but I keep getting a error that "[DBNETLIB][ConnectionOpen(Connect()).] SQLServer does not exist or access denied" in visual studio whenever I try creating a new database connection. How do I know if SQL server is installed on my system? cuz in my systray I see SQL server service manager, is that the same thing as SQL server? or do I need to download the full version or something? also could it be that a certain port on my system is not open that SQL server requires to be open?

Thanks

Ron

The tray icon doesn't mean SQL is running, so use the tray icon to start SQL if it isn't. I do not know if SQL Express uses a tray icon, so i would assume you are using MSDE 2000. You might need to grant the user ASPNET access to the database.

SQL uses Port 1433. DTE services use ports 5000-5020, however I don't think you are using DTE.

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I installed the SQL SERVER , Oracleclient on my computer, and I can connect to remote SQL server,oracle databases using wizards , however when I try to run application iam getting this error.

Server Error in '/shiva/datagrd' Application.

---

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

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.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Source Error:

Line 40: //SqlDataAdapter da=new SqlDataAdapter("select * from sms",con);
Line 41: DataSet ds=new DataSet();
Line 42: da.Fill(ds,"tab");
Line 43: DataGrid1.DataSource=ds.Tables[0].DefaultView;
Line 44: DataGrid1.DataBind();

Source File:e:\shiva\datagrd\webform1.aspx.cs Line:42

Stack Trace:

[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]
 System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
 System.Data.OleDb.OleDbConnection.InitializeProvider()
 System.Data.OleDb.OleDbConnection.Open()
 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
 datagrd.WebForm1.Page_Load(Object sender, EventArgs e) in e:\shiva\datagrd\webform1.aspx.cs:42
 System.Web.UI.Control.OnLoad(EventArgs e)
 System.Web.UI.Control.LoadRecursive()
 System.Web.UI.Page.ProcessRequestMain()

---

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

please provide the solution.

What is your sql connection string in your web application?

|||

string strCon="Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=Anjali;Data Source=MIPL0121;Persist Security Info=False"; //my connection string

and it is existing i am able to see the data through microsoft sql server --> enterprise manager

and i am able to get the data for my windows applications but not for web application why?

|||

You would have to use:

String strCon = "Server=MIPL0121;Database=Anjali;User ID=myuser;password=mypassword;"

|||

still problem is like that only

i think problem with some other one not with connection string

https://secure.experts-exchange.com/register.jsp?srid=m6c%2BKpauvxfudZgRmo%2Fm6A%3D%3D&rsid=20&viewQuestionRedirectURL=%2FDatabase%2FOracle%2FQ_20402341.html%3Fqid%3D20402341%26qid%3D20402341&submit=

my problem is exact as this

|||

Hi,

This is definately a security issue. In you connection string, you're using the Windows integrated authentication to connection to the server.

You can do this in the VS.NET because it is using your windows identity(Running under your account). However, the ASP.NET app is running under the ASPNET account, which doesn't have that previlege.

To resolve this, you can either give the ASPNET account proper permission to access the database, or use other accounts for accessing the database.

|||but i am able to get the data from remote server using same connection string in vs2005 but not in 2003 why?|||at the same time i am not able to get the data from ORACLE also and the connection string and code is perfectly executing on my neighbor system.|||at the same time i am not able to get the data from ORACLE also andthe connection string and code is perfectly executing on my neighborsystem with the same setting|||

Hi,

I'd like to know if you're connecting from VS.NET IDE using this connection string. Or you're using this connection string in your ASP.NET application.

Because in different scenarios, it holds different user credentials. Also, please check if you have used the correct OleDb driver to do the connection to SQL Server.

|||

ya i am using this connection string in asp.net application

but i tryied by using vs.net IDE(using Wizards) also its givng the same error when i am connecting throw wizards it is connecting and showing the database contents(mean if a select a tabe it

showing the discription of that table ) but when i am running the application it giving the above error

[324] SQLAgent is not allowed to run.

I have two instances of SQL 2000 installed. SQLAgent on
one starts ok. However SQLAgent on the second instance
does NOT start. The one that does not work is for
SHAREPOINT. I am running SBS 2003. Both MSSQL servers
start ok.
Originally the SHAREPOINT server was MSDE but I upgraded
it to SQL 2000.That's not much to go on. What is the error msg? You might want to check
to ensure the account and password SQL Agent is running under are valid.
--
Andrew J. Kelly SQL MVP
"Dennis Cullen" <anonymous@.discussions.microsoft.com> wrote in message
news:070301c3d793$1657e810$a501280a@.phx.gbl...
> I have two instances of SQL 2000 installed. SQLAgent on
> one starts ok. However SQLAgent on the second instance
> does NOT start. The one that does not work is for
> SHAREPOINT. I am running SBS 2003. Both MSSQL servers
> start ok.
> Originally the SHAREPOINT server was MSDE but I upgraded
> it to SQL 2000.|||I have a similar problem; running SPS 2003. Took the box out of the network and when booted, SQLAgent$SHAREPOINT died. After much research, the setting in the registry was somehow truncated (the DependsOn Service was truncated to MSSQL$SHAREPOINT to MSSQL$SHA) - no idea how THAT happened.
At any rate, while I've corrected the above, any attempt to start SQLAgent (even on the command line) simply returns "SQLAgent is not allowed to run". Only error message I can see is "StartServiceCtrlDispatcher failed (error 6)".
NO info anywhere so far on this type of problem; NOTE: Recently applied the Security patch however, I am skeptical about that being the problem as all other Databases are working fine.
Any ideas?|||After Much Much searching, I located the information on Google (!); this relates the SHAREPOINT ONLY that I know of...In the registry, find
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MICROSOFT SQL SERVER/SHAREPOINT/SQLSERVERAGEN
and delete the GUID entry - this corrects the problem. This was posted by chrisfez is the DBForum as the solution provided by Microsoft Support. ALSO NOTE: There is a similar problem with UDDI, though I am just now investigating it (start up of the Sql Agent for UDDI fails the same as SharePoint).|||Thanks, this solved my problem
Google (!); this relates the SHAREPOINT ONLY that I know
of...In the registry, find:
>HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MICROSOFT SQL
SERVER/SHAREPOINT/SQLSERVERAGENT
>and delete the GUID entry - this corrects the problem.
This was posted by chrisfez is the DBForum as the solution
provided by Microsoft Support.

[324] SQLAgent is not allowed to run.

I have two instances of SQL 2000 installed. SQLAgent on
one starts ok. However SQLAgent on the second instance
does NOT start. The one that does not work is for
SHAREPOINT. I am running SBS 2003. Both MSSQL servers
start ok.
Originally the SHAREPOINT server was MSDE but I upgraded
it to SQL 2000.That's not much to go on. What is the error msg? You might want to check
to ensure the account and password SQL Agent is running under are valid.
Andrew J. Kelly SQL MVP
"Dennis Cullen" <anonymous@.discussions.microsoft.com> wrote in message
news:070301c3d793$1657e810$a501280a@.phx.gbl...

quote:

---

> I have two instances of SQL 2000 installed. SQLAgent on
> one starts ok. However SQLAgent on the second instance
> does NOT start. The one that does not work is for
> SHAREPOINT. I am running SBS 2003. Both MSSQL servers
> start ok.
> Originally the SHAREPOINT server was MSDE but I upgraded
> it to SQL 2000.

---

|||I have a similar problem; running SPS 2003. Took the box out of the network
and when booted, SQLAgent$SHAREPOINT died. After much research, the setting
in the registry was somehow truncated (the DependsOn Service was truncated t
o MSSQL$SHAREPOINT to MSSQL
$SHA) - no idea how THAT happened.
At any rate, while I've corrected the above, any attempt to start SQLAgent (
even on the command line) simply returns "SQLAgent is not allowed to run". O
nly error message I can see is "StartServiceCtrlDispatcher failed (error 6)"
.
NO info anywhere so far on this type of problem; NOTE: Recently applied the
Security patch however, I am skeptical about that being the problem as all o
ther Databases are working fine.
Any ideas?|||After Much Much searching, I located the information on Google (!); this rel
ates the SHAREPOINT ONLY that I know of...In the registry, find:
HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MICROSOFT SQL SERVER/SHAREPOINT/SQLSER
VERAGENT
and delete the GUID entry - this corrects the problem. This was posted by ch
risfez is the DBForum as the solution provided by Microsoft Support. ALSO NO
TE: There is a similar problem with UDDI, though I am just now investigating
it (start up of the Sql Ag
ent for UDDI fails the same as SharePoint).|||Thanks, this solved my problem
Google (!); this relates the SHAREPOINT ONLY that I know
of...In the registry, find:

quote:

---

>HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/MICROSOFT SQL

---

SERVER/SHAREPOINT/SQLSERVERAGENT

quote:

---

>and delete the GUID entry - this corrects the problem.

---

This was posted by chrisfez is the DBForum as the solution
provided by Microsoft Support.

[?] Error accessing from internet

I've installed Reporting Services and customized the authentication ( Forms
Authentication Sample ) with SSL.
Everything works fine in intranet environment.
Now I'm trying to publish this server in internet, but it doesn't work:
when I call the server url I can see the login form, but when I press the
"Login" button nothing happens.
I debugged the application and see the request coming in correctly, the
login credentials are authenticated but the redirect to the
"/Pages/Folder.aspx" is wrong.
It seems like the report manager and the report server can't communicate
each other when accessed from internet.
May the SSL certificate be released on Netbios name but the internet access
is something like www.myserver.com ?
Thanks for responses.
MorenoI had a similar problem. What I did was add a entry into my host file
on the server. Make sure your internal ip for the server matches your
domain name. Hope this helps.
Example:
10.0.0.1 yourssldomain.com
"Moreno" <movendra@.yahoo.com> wrote in message news:<#Q$tpBtWEHA.3800@.TK2MSFTNGP11.phx.gbl>...
> I've installed Reporting Services and customized the authentication ( Forms
> Authentication Sample ) with SSL.
> Everything works fine in intranet environment.
> Now I'm trying to publish this server in internet, but it doesn't work:
> when I call the server url I can see the login form, but when I press the
> "Login" button nothing happens.
> I debugged the application and see the request coming in correctly, the
> login credentials are authenticated but the redirect to the
> "/Pages/Folder.aspx" is wrong.
> It seems like the report manager and the report server can't communicate
> each other when accessed from internet.
> May the SSL certificate be released on Netbios name but the internet access
> is something like www.myserver.com ?
> Thanks for responses.
> Moreno

@@version, add database to a named instance?

Hi,
I have a sql 2000 personal editon(default server) and developer edition
(named) installed on a machine (windowsXP).
1) if I do 'select @.@.version' in query, I always get 'personal edition'
version information back. How can I get the version nformation of developer
edition?
2)How do I use Enterprise Manager to create a database with developer editon
server instance?
THANKS!
It tells you the version of the server you are connecting to. If you want
the version of developer edition you need to connect to it first.
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
> Hi,
> I have a sql 2000 personal editon(default server) and developer edition
> (named) installed on a machine (windowsXP).
> 1) if I do 'select @.@.version' in query, I always get 'personal edition'
> version information back. How can I get the version nformation of
> developer
> edition?
> 2)How do I use Enterprise Manager to create a database with developer
> editon
> server instance?
> THANKS!
|||"ME",
I couldn't find a way to 'connect' to the server instance of developer
edition in the sql enterprise maganer. Hope you can help me on this. Thanks
!!
"ME" wrote:

> It tells you the version of the server you are connecting to. If you want
> the version of developer edition you need to connect to it first.
>
> "bangwo" <bangwo@.discussions.microsoft.com> wrote in message
> news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
>
>
|||well, if you open Server Network Utility you should see the instance name of
your SQL Edition server. Use that instance name to connect ...
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
|||Hello,
Go to the SQL Server log of the SQL Server Developer edition installation
(C:\program files\Microsoft SQL Server\Logs\ folder).
In the error log the name of the SQL Server installation will be shown. You
could use that information to either register to Enterprise manager or
connect to Query Analyzer. After that you could execute SELECT @.@.Version.
Thanks
hari
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:

@@version, add database to a named instance?

Hi,
I have a sql 2000 personal editon(default server) and developer edition
(named) installed on a machine (windowsXP).
1) if I do 'select @.@.version' in query, I always get 'personal edition'
version information back. How can I get the version nformation of developer
edition?
2)How do I use Enterprise Manager to create a database with developer editon
server instance?
THANKS!It tells you the version of the server you are connecting to. If you want
the version of developer edition you need to connect to it first.
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
> Hi,
> I have a sql 2000 personal editon(default server) and developer edition
> (named) installed on a machine (windowsXP).
> 1) if I do 'select @.@.version' in query, I always get 'personal edition'
> version information back. How can I get the version nformation of
> developer
> edition?
> 2)How do I use Enterprise Manager to create a database with developer
> editon
> server instance?
> THANKS!|||"ME",
I couldn't find a way to 'connect' to the server instance of developer
edition in the sql enterprise maganer. Hope you can help me on this. Thanks
!!
"ME" wrote:

> It tells you the version of the server you are connecting to. If you want
> the version of developer edition you need to connect to it first.
>
> "bangwo" <bangwo@.discussions.microsoft.com> wrote in message
> news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
>
>|||well, if you open Server Network Utility you should see the instance name of
your SQL Edition server. Use that instance name to connect ...
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
>|||Hello,
Go to the SQL Server log of the SQL Server Developer edition installation
(C:\program files\Microsoft SQL Server\Logs\ folder).
In the error log the name of the SQL Server installation will be shown. You
could use that information to either register to Enterprise manager or
connect to Query Analyzer. After that you could execute SELECT @.@.Version.
Thanks
hari
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
>

@@Version still shows Service Pack 1

We just installed the service pack 2 to our server, so I did a select @.@.version but it's still say Service Pack 1, even though the version number is now 3054. Is that a bug in the service pack?

Thanks.

Can you post the entire string returned by SELECT @.@.VERSION? My guess is that you are seeing the Windows OS Service Pack that is also included in the @.@.VERSION call. SQL Server should return SP2.

Thanks,

Sam Lester (MSFT)

|||Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
|||

Yeah, the SP1 in this case refers to your Windows Version:

Windows NT 5.2 (Build 3790: Service Pack 1)

The Service Pack level apparently isn't listed in the @.@.VERSION as I thought it was. Build 3054 is definitely SP2, but you can also check Add/Remove Programs report or the setup regitry hives to confirm.

Thanks,
Sam Lester (MSFT)

|||
Thanks for your help.

@@Version not updating

Greetings,
I recently installed Service Pack 4 on SQL 2000. The install went
smooth with no errors and a message at the end stating the install
completed successfully. I rebooted the server (Windows Server '03) and
tried to check the @.@.Version global variable but it still lists only
Service Pack 1.
Could it be that SP4 didn't install? Or is it more likely something
else is preventing the @.@.Version from updating?
Thanks in advance,
BenHi Ben
What do you get from
SELECT SERVERPROPERTY('ProductLevel')
HTH
Kalen Delaney, SQL Server MVP
"sullins602" <ben.sullins@.gmail.com> wrote in message
news:1152814872.081466.270730@.s13g2000cwa.googlegroups.com...
> Greetings,
> I recently installed Service Pack 4 on SQL 2000. The install went
> smooth with no errors and a message at the end stating the install
> completed successfully. I rebooted the server (Windows Server '03) and
> tried to check the @.@.Version global variable but it still lists only
> Service Pack 1.
> Could it be that SP4 didn't install? Or is it more likely something
> else is preventing the @.@.Version from updating?
> Thanks in advance,
> Ben
>|||Hi Ben,
Looks like @.@.version does not show the SQL Server service pack number but a
version number. Check for a number like 8.00.2039. Probably the service pack
listed is for the operating system.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"sullins602" wrote:

> Greetings,
> I recently installed Service Pack 4 on SQL 2000. The install went
> smooth with no errors and a message at the end stating the install
> completed successfully. I rebooted the server (Windows Server '03) and
> tried to check the @.@.Version global variable but it still lists only
> Service Pack 1.
> Could it be that SP4 didn't install? Or is it more likely something
> else is preventing the @.@.Version from updating?
> Thanks in advance,
> Ben
>|||Thats it! I was looking at the service pack for the OS not the
database. Thanks for your help fellas...
-ben