no longer can access database after changing password

I can no longer can access my database after changing my password for windows even though I changed it back.
Posted: 02 Sep 2003 09:18 PM
My wife started my computer and was prompted to change the password(win 2K Prof) and she did. Grrrrrrrrrr.
After logging in under the new password, I changed it back to the origional.
Ever since, I can not connect or start the database(sql 2k). I receive the error:
SQL Server does not exist or access denied.
Please help me.
Thanks
Gregdo u have Enterprise Manager to see if Database Exists,if does,try to change your TCP/IP port under EnterPrise Manage to 1442 maybe works I've got this problem before but It's doesn't seem to be for Changing password,

I hope it helps|||can you see your db's through the SQL server xplorer. ..|||Thank You for the Ideas.
I dont know what the sql xplorer is, but when I try to access the database through the enterprise manager, I get the error: (Connection failed, check SQL Server Registration Properties.)
Another thing that happened after the changing password incident, is that I must login to these forums and they wont let me automatically login.
this leads me to believe that it has something to do with the users on my computer.
Greg|||check your log files under

C:\Program Files\Microsoft SQL Server\MSSQL\LOG folder.

if you see any files try opening one of the files with a note pad. your registration prbly expired.

HTH.|||I checked that file:

2003-09-01 15:23:03.84 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)

2003-09-01 15:23:03.95 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-09-01 15:23:03.95 server All rights reserved.
2003-09-01 15:23:03.95 server Server Process ID is 764.
2003-09-01 15:23:03.95 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-09-01 15:23:04.36 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-09-01 15:23:05.72 server SQL Server configured for thread mode processing.
2003-09-01 15:23:05.86 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-09-01 15:23:07.85 spid3 Starting up database 'master'.
2003-09-01 15:23:12.49 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-09-01 15:23:12.49 spid5 Starting up database 'model'.
2003-09-01 15:23:12.69 spid3 Server name is 'VAIO'.
2003-09-01 15:23:12.69 spid3 Skipping startup of clean database id 4
2003-09-01 15:23:15.10 spid5 Clearing tempdb database.
2003-09-01 15:23:23.00 spid5 Starting up database 'tempdb'.
2003-09-01 15:23:25.04 spid3 Recovery complete.
2003-09-01 15:23:25.05 spid3 SQL global counter collection task is created.
2003-09-01 15:23:34.13 server SQL server listening on Shared Memory.
2003-09-01 15:23:34.13 server SQL Server is ready for client connections
2003-09-02 01:20:10.93 server SQL Server terminating because of system shutdown.

I dont really know what this means.
greg|||your sql server seems to be working fine. can you still not connect through enterprise manager ? start - programs - Microsoft Sql server - enterprise manager.
do you see your server ?|||Yes, I can see the server but it won't refresh or start.
Greg|||I just noticed that the above file refers to the server VAIO which is an MSDE that is running. The server that is not working is VAIO\SUNS. None of the six log files mention that server.

Also, it was the service manager that I can not refresh or start VAIO\SUNS. When I checked in the enterprise manager, I also found the server not running and when I click on it i get an error:(Connection failed, check SQL Server Registration Properties)
Thank you so far for all your help on this!
Greg|||under administrative tools, if you double click on services, you will see a list of all the services in your system. scroll down and find MSSQLSERVER. you can see a 'status' column. wat does it say ? started/stopped? see if you can start the sqlserver frm here.|||if nothing works, may be you can make a copy of the data folder under c:\program files\MS Sql Server\Data and reinstall the SQL Server. and copy the files frm the Data folder back to to the new Data folder.|||MSSQLSERVER is started, but MSSQL$SUNS is not(we already knew this though)

I tried to start MSSQL$SUNS and got the following error:
Could not start the MSSQL$SUNS on Local Computer.
The service did not return an error. This could be an internal Windows error or an internal service error.
If the problem persists, contact your system administrator.

I then tried to login under different user accounts and got the same error.|||are you logged in as admin? or atleast a user with admin privileges ?
also, can you access your sql through query analyzer ?|||I took your advice and reinstalled SQL server. I transfered the data file and everything is running. I can see the old tables in the newly installed server.

The only problem now is that when i try to open my application at http://localhost/default.aspx, I get this error:

---------------
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
---------------

Would it help if I post: C:\Program Files\Microsoft SQL Server\MSSQL$SUNS\LOG
Greg|||(1) can you make out if your webserver is running fine? just write a small test.html and try opening it frm localhost and see if its wrking.

(2) can you see your old files ? i think you need to 'attach' your old databases.
on the enterprise manager ( which i call sql server explorer), when you expand 'databases'
do you see your db ? right click on the 'databases' and 'attach database'. browse to the data folder of the ms sql server and select the db.

(3) is your sql server name the same as the old one ? or did you name it differently ?

No Data Selected message back to .Net

Hi All
We have a .net application calling some reporting services reports and we
pass the parameters to the reports from the application.
When no data is selected, is there any way to pass a paramter or something
back to the .net application so that we can display a 'No data selected'
message within the .net application.
Thanks
PeteI don't know if you can hook into this at the report level, but the data
regions (table, subreport, matrix, etc.) have a NoRows property that can
display a message if the source data set is empty.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"P" <P@.discussions.microsoft.com> wrote in message
news:B52C45F6-E67A-42B9-8517-3107FA071C93@.microsoft.com...
> Hi All
> We have a .net application calling some reporting services reports and we
> pass the parameters to the reports from the application.
> When no data is selected, is there any way to pass a paramter or something
> back to the .net application so that we can display a 'No data selected'
> message within the .net application.
> Thanks
> Pete

No Data returned from OPENQUERY to Active Directory

I am trying to query our active directory for user information, but even
though I get the query to work I am getting no data back. I have a linked
server to the active directory from SQL Server 2000 and I am running the
query in the Query Analyzer.
My query is as follows:
select * from openquery(adsi, 'select name, homephone from
''ldap://DC=mydomain,DC=com'' where objectclass = ''User'' ')
This query will complete without error, but no data is returned. I have
seen one other question of this nature here, but I saw no final resolution.
What is wrong?
Alan
Message posted via http://www.sqlmonster.com
Bruce,
thanks for the response, but I tried what you suggested and still the query
returned no data. It completed without error just no data.
Thanks,
Alan
Message posted via http://www.sqlmonster.com
|||Alan, not sure why youre getting no data back then.
You're sure of the domain name? there's no special
security on your AD to prevent you from accessing? The
linked sever is setup correctly? like so..?
sp_addlinkedserver 'ADSI', 'Active Directory Service
Interfaces', 'ADSDSOObject', 'adsdatasource'
go
Are you sure the data sits in the User ObjectClass?
Might be somewhere else, check it.
There was a max 1000 row limit by default and we had to
have that kicked up to get more then 1000 rows returned.
These links talk about that...
http://support.novell.com/cgi-
bin/search/searchtid.cgi?/10081596.htm
http://www.ldapadministrator.com/for...topic.php?t=14

>--Original Message--
>Bruce,
>thanks for the response, but I tried what you suggested
and still the query
>returned no data. It completed without error just no
data.
>Thanks,
>Alan
>--
>Message posted via http://www.sqlmonster.com
>.
>
|||Bruce,
I ran an export of the data in the user objects using ldifde and got back
exactly what I expected, but the same query in SQL Server Query Analyzer
comes back empty.
I guess it could be something with the link, but it was set up according to
the instructions I found on the web. The link was created in Enterprise
manager, but using the same settings that you specified in the
sp_addlinkedserver statement. It could also be a user security issue, but
I have tried logining in as the admin, SQL Sever admin and myself with no
data back.
Still playing around with it.
Alan
Message posted via http://www.sqlmonster.com
|||Finally, thanks Bruce. I was reading your posting and I was finally able to
pull data.
I'm trying to pull just users that are a member of a certain group, how can
I do that?
This is what I have but not working; however, I was able to used your query
just to get a start and that was a big help.
SELECT *
FROM OPENQUERY( ADSI,
'SELECT cn
FROM ''LDAP://internal/OU=Account
Executives,DC=internal,DC=homequest,DC=com''
WHERE objectClass = ''users''')
GO
"Bruce de Freitas" wrote:

> Alan, not sure if it matters, but I usually do the
> ADIS/LDAP calls more like this format... Check the
> Linked Server also, for correct setup and security. Bruce
>
> SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
> ((objectClass=User));distinguishedname,homePhone')
> where distinguishedname like '%a%'
>
> information, but even
> back. I have a linked
> I am running the
> from
> = ''User'' ')
> returned. I have
> no final resolution.
>
|||Sonya, this query would list all the GROUPs.
SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
(&(objectCategory=GROUP)); distinguishedname,CN')
You'd then have to join all the Users to what groups they are in, if
that is what youre trying to do... Bruce
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Thank you, after playing with it for awhile I was able to get it to work.
Do you know if there is a way to extract users' contact folder from the
server-level?
"Bruce de Freitas" wrote:

> Sonya, this query would list all the GROUPs.
> SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
> (&(objectCategory=GROUP)); distinguishedname,CN')
>
> You'd then have to join all the Users to what groups they are in, if
> that is what youre trying to do... Bruce
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>

No Data returned from OPENQUERY to Active Directory

I am trying to query our active directory for user information, but even
though I get the query to work I am getting no data back. I have a linked
server to the active directory from SQL Server 2000 and I am running the
query in the Query Analyzer.
My query is as follows:
select * from openquery(adsi, 'select name, homephone from
''ldap://DC=mydomain,DC=com'' where objectclass = ''User'' ')
This query will complete without error, but no data is returned. I have
seen one other question of this nature here, but I saw no final resolution.
What is wrong?
Alan
--
Message posted via http://www.sqlmonster.comAlan, not sure if it matters, but I usually do the
ADIS/LDAP calls more like this format... Check the
Linked Server also, for correct setup and security. Bruce
SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
((objectClass=User));distinguishedname,homePhone')
where distinguishedname like '%a%'
>--Original Message--
>I am trying to query our active directory for user
information, but even
>though I get the query to work I am getting no data
back. I have a linked
>server to the active directory from SQL Server 2000 and
I am running the
>query in the Query Analyzer.
>My query is as follows:
>select * from openquery(adsi, 'select name, homephone
from
>''ldap://DC=mydomain,DC=com'' where objectclass
= ''User'' ')
>This query will complete without error, but no data is
returned. I have
>seen one other question of this nature here, but I saw
no final resolution.
>What is wrong?
>Alan
>--
>Message posted via http://www.sqlmonster.com
>.
>|||Bruce,
thanks for the response, but I tried what you suggested and still the query
returned no data. It completed without error just no data.
Thanks,
Alan
--
Message posted via http://www.sqlmonster.com|||Alan, not sure why youre getting no data back then.
You're sure of the domain name? there's no special
security on your AD to prevent you from accessing? The
linked sever is setup correctly? like so..'
sp_addlinkedserver 'ADSI', 'Active Directory Service
Interfaces', 'ADSDSOObject', 'adsdatasource'
go
Are you sure the data sits in the User ObjectClass?
Might be somewhere else, check it.
There was a max 1000 row limit by default and we had to
have that kicked up to get more then 1000 rows returned.
These links talk about that...
http://support.novell.com/cgi-
bin/search/searchtid.cgi?/10081596.htm
http://www.ldapadministrator.com/forum/viewtopic.php?t=14
>--Original Message--
>Bruce,
>thanks for the response, but I tried what you suggested
and still the query
>returned no data. It completed without error just no
data.
>Thanks,
>Alan
>--
>Message posted via http://www.sqlmonster.com
>.
>|||Bruce,
I ran an export of the data in the user objects using ldifde and got back
exactly what I expected, but the same query in SQL Server Query Analyzer
comes back empty.
I guess it could be something with the link, but it was set up according to
the instructions I found on the web. The link was created in Enterprise
manager, but using the same settings that you specified in the
sp_addlinkedserver statement. It could also be a user security issue, but
I have tried logining in as the admin, SQL Sever admin and myself with no
data back.
Still playing around with it.
Alan
--
Message posted via http://www.sqlmonster.com|||Finally, thanks Bruce. I was reading your posting and I was finally able to
pull data.
I'm trying to pull just users that are a member of a certain group, how can
I do that?
This is what I have but not working; however, I was able to used your query
just to get a start and that was a big help.
SELECT *
FROM OPENQUERY( ADSI,
'SELECT cn
FROM ''LDAP://internal/OU=Account
Executives,DC=internal,DC=homequest,DC=com''
WHERE objectClass = ''users''')
GO
"Bruce de Freitas" wrote:
> Alan, not sure if it matters, but I usually do the
> ADIS/LDAP calls more like this format... Check the
> Linked Server also, for correct setup and security. Bruce
>
> SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
> ((objectClass=User));distinguishedname,homePhone')
> where distinguishedname like '%a%'
>
> >--Original Message--
> >I am trying to query our active directory for user
> information, but even
> >though I get the query to work I am getting no data
> back. I have a linked
> >server to the active directory from SQL Server 2000 and
> I am running the
> >query in the Query Analyzer.
> >
> >My query is as follows:
> >
> >select * from openquery(adsi, 'select name, homephone
> from
> >''ldap://DC=mydomain,DC=com'' where objectclass
> = ''User'' ')
> >
> >This query will complete without error, but no data is
> returned. I have
> >seen one other question of this nature here, but I saw
> no final resolution.
> >What is wrong?
> >
> >Alan
> >
> >--
> >Message posted via http://www.sqlmonster.com
> >.
> >
>|||Thank you, after playing with it for awhile I was able to get it to work.
Do you know if there is a way to extract users' contact folder from the
server-level?
"Bruce de Freitas" wrote:
> Sonya, this query would list all the GROUPs.
> SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
> (&(objectCategory=GROUP)); distinguishedname,CN')
>
> You'd then have to join all the Users to what groups they are in, if
> that is what youre trying to do... Bruce
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>sql

Nixing a Transaction Log

Is it possible to nix a transaction log without backing it
up? My disk is not large enought to back it up and the
snapshot agent continually tells me that there is not
enough space (error 112) although I have 5GB Free on the
array.
Sql 2k
daveWe were just having this same issue - and did this.
With nobody in the DB - so you are sure that no log
activity is going on.
Not sure it's the safest thing to do...
In query analyzer do BACKUP LOG dbname WITH TRUNCATE_ONLY
Them back to Enterprise Manager - right click on DB - all
tasks - SHRINK FILES - click on the FILES cmd button -
choose the log file from the drop down and press OK /
then press CANCEL when you get back to the SHRINK FILES
dialog box.
This dropped the size of the log file to 1024 k
MS KB article give you different (but similar steps):
http://support.microsoft.com/default.aspx?scid=kb;en-
us;272318
>--Original Message--
>Is it possible to nix a transaction log without backing
it
>up? My disk is not large enought to back it up and the
>snapshot agent continually tells me that there is not
>enough space (error 112) although I have 5GB Free on the
>array.
>Sql 2k
>dave
>.
>|||Thanks! That totally helped out in the biggest way!!!
Dave
>--Original Message--
>We were just having this same issue - and did this.
>With nobody in the DB - so you are sure that no log
>activity is going on.
>Not sure it's the safest thing to do...
>In query analyzer do BACKUP LOG dbname WITH TRUNCATE_ONLY
>Them back to Enterprise Manager - right click on DB - all
>tasks - SHRINK FILES - click on the FILES cmd button -
>choose the log file from the drop down and press OK /
>then press CANCEL when you get back to the SHRINK FILES
>dialog box.
>This dropped the size of the log file to 1024 k
>MS KB article give you different (but similar steps):
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;272318
>>--Original Message--
>>Is it possible to nix a transaction log without backing
>it
>>up? My disk is not large enought to back it up and the
>>snapshot agent continually tells me that there is not
>>enough space (error 112) although I have 5GB Free on the
>>array.
>>Sql 2k
>>dave
>>.
>.
>

Newbie-shrink transaction log files

Hi. I know this is an often-discussed topic, but I hope you can clear up
some confusion for me. I set up a SQL Server 2005 maintenance plan to back
up my databases to disk (we also backup to tape using Backup Exec). My goals
in backing up to disk are 1) to have a couple days of backups on disk in case
I need to do quick restores, and 2) to reduce the size of transaction log
files. In the maint plan, I selected the options to shrink the databases,
backup databases (full), and backup transaction logs. The problem is that
when I executed the maint plan, it didn't reduce the size of the transaction
log physical files which are growing.
I grabbed this SQL code from the Internet, and it works to shrink the tran
log file size:
USE mydb
BACKUP LOG mydb WITH TRUNCATEONLY
DBCC SHRINKFILE [mydb_log, TRUNCATEONLY]
GO
I want to automate this task. I don't want to have to edit the above script
every time I create or drop a database. I know I can just have a SQL Agent
job run the script, BUT isn't the maintenance job supposed to shrink tran log
files as part of the "Backup Database (Full)" and Backup Database
"(Transaction Log)" options?
By the way, is the BACKUP LOG statement required to precede the DBCC
SHRINKFILE statement?
Thanks for your help.Hi Coop,
I see a couple of problems with your request. First, do not shrink your
database and transaction log files periodically. When you shrink a file, the
next thing SQL Server will do is to expand these files to do its work, and
shrinking and expanding these files periodically could be a performance
problem in addition to creating more disk fragmentation that probably will
also affect the performance of your database. My recommendation here is just
schedule full database and transaction log backups. You can still shrink the
files manually once in a while only if you need it.
Second, you want to use TRUNCATE_ONLY which truncates the log without really
doing a backup. The problem here is that you are not doing a transaction log
backup and you are breaking the log chain. I recommend here that you see the
SQL Server documentation (BOL) and understand the SQL Server recovery models
simple, bulk-logged and full. If you really need to use TRUNCATE_ONLY better
change the recovery model to simple.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Coop" wrote:
> Hi. I know this is an often-discussed topic, but I hope you can clear up
> some confusion for me. I set up a SQL Server 2005 maintenance plan to back
> up my databases to disk (we also backup to tape using Backup Exec). My goals
> in backing up to disk are 1) to have a couple days of backups on disk in case
> I need to do quick restores, and 2) to reduce the size of transaction log
> files. In the maint plan, I selected the options to shrink the databases,
> backup databases (full), and backup transaction logs. The problem is that
> when I executed the maint plan, it didn't reduce the size of the transaction
> log physical files which are growing.
> I grabbed this SQL code from the Internet, and it works to shrink the tran
> log file size:
> USE mydb
> BACKUP LOG mydb WITH TRUNCATEONLY
> DBCC SHRINKFILE [mydb_log, TRUNCATEONLY]
> GO
> I want to automate this task. I don't want to have to edit the above script
> every time I create or drop a database. I know I can just have a SQL Agent
> job run the script, BUT isn't the maintenance job supposed to shrink tran log
> files as part of the "Backup Database (Full)" and Backup Database
> "(Transaction Log)" options?
> By the way, is the BACKUP LOG statement required to precede the DBCC
> SHRINKFILE statement?
> Thanks for your help.|||Coop
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
"Coop" <Coop@.discussions.microsoft.com> wrote in message
news:91C8FA70-23CF-4D9A-8879-93EC8EDAEF71@.microsoft.com...
> Hi. I know this is an often-discussed topic, but I hope you can clear up
> some confusion for me. I set up a SQL Server 2005 maintenance plan to
> back
> up my databases to disk (we also backup to tape using Backup Exec). My
> goals
> in backing up to disk are 1) to have a couple days of backups on disk in
> case
> I need to do quick restores, and 2) to reduce the size of transaction log
> files. In the maint plan, I selected the options to shrink the databases,
> backup databases (full), and backup transaction logs. The problem is that
> when I executed the maint plan, it didn't reduce the size of the
> transaction
> log physical files which are growing.
> I grabbed this SQL code from the Internet, and it works to shrink the tran
> log file size:
> USE mydb
> BACKUP LOG mydb WITH TRUNCATEONLY
> DBCC SHRINKFILE [mydb_log, TRUNCATEONLY]
> GO
> I want to automate this task. I don't want to have to edit the above
> script
> every time I create or drop a database. I know I can just have a SQL
> Agent
> job run the script, BUT isn't the maintenance job supposed to shrink tran
> log
> files as part of the "Backup Database (Full)" and Backup Database
> "(Transaction Log)" options?
> By the way, is the BACKUP LOG statement required to precede the DBCC
> SHRINKFILE statement?
> Thanks for your help.