Establishing connection from SQL MMC fails

Hi,
I have Win2003 and SQL server 2000 installed. I have restarted SQL services
and the services crashed and could not be killed. I have killed the
processes manually but when I open SQL Server Enterprise Manager, expand SQL
Server group and click on the desired SQL Server group it is failing and the
MMC becomes not responding.
It fails on 'Establing connection to SQL Server and checking Windows
security'
I have tried to telnet on the respective SQL Server port and the port
responds ok. I have also done a netstat and the server is listening on the
respective port.
From the sql error logs, the following information is being logged
2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in database
'msdb' (4)
2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for buffer
latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID 4:2073058421:0,
EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
0x10000a, current owning EC 0x42CAC3F0.
Your suggetions will be highly appreciated.Dear Quintin,
Thank you for posting here.
From the problem description, I understand that the error message
"Establish connection to SQL Server and checking Windows security" is
encountered when trying to connect to the SQL Server 2000 via the
Enterprise Manage. If I have misunderstood about your concern, feel free to
let me know.
Before moving on, I suggest that you try the following method to check if
you could connect via osql.exe
1. Click Start, click Run, type cmd, and then click OK
2. At the command prompt, type the following command, and then press ENTER.
OSQL -E -S <server name>\<instance name>
OSQL -E -S tcp:<computer name>,<port number>
Also, you could try SQL authentication by using sa
OSQL -S <server name>\<instance name> -Usa -P<password>
3. Please check if we can successfully connect to the instance of SQL
Server 2000 by using osql.exe.
If any error message appears, please let me know the extract error message
we received.
Please also help me gather the following information for the further
research:
Information One: SQL MPS Report
=====================Please help create a MPSReport on the problematic machine, which will
collect ERRORLOG, Windows event log and other helpful information about the
SQL Server. To create a MPSReport, please visit the following web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
88B7-F9C79B7306C0&displaylang=en
And look for MPSRPT_SQL.EXE. Download it and run it on the machine. Dismiss
the prompted dialog boxes and the readme window (usually a Notepad) after
you read them. After the Command Prompt window closes itself, collect the
cab file the tool has generated and sent it to me.
Information Two: Screenshot
=====================Please also help me to capture a screenshot when the error message
"Establish connection to SQL Server and checking Windows security" appears.
1. When the error appears, please press the Print Screen key (PrtScn) on
your keyboard.
2. Click Start, click Run, type MSPAINT, and click OK.
3. In Paint, click Paste under the Edit Menu, click Save under the File
menu, type a file name for the snap shot, choose JPEG as "Save as type",
click "Desktop" on the left pane, and click Save.
Please send above files to me at v-adamqu@.microsoft.com
If anything is unclear in my post, please don't hesitate to let me know and
I will be glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "Quintin Zammit" <qztarantino@.newsgroup.nospam>
| Subject: Establishing connection from SQL MMC fails
| Date: Wed, 26 Sep 2007 19:27:40 +0200
| Lines: 30
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 80.85.100.38
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26395
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
|
| I have Win2003 and SQL server 2000 installed. I have restarted SQL
services
| and the services crashed and could not be killed. I have killed the
| processes manually but when I open SQL Server Enterprise Manager, expand
SQL
| Server group and click on the desired SQL Server group it is failing and
the
| MMC becomes not responding.
|
| It fails on 'Establing connection to SQL Server and checking Windows
| security'
|
| I have tried to telnet on the respective SQL Server port and the port
| responds ok. I have also done a netstat and the server is listening on
the
| respective port.
|
| From the sql error logs, the following information is being logged
|
| 2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in
database
| 'msdb' (4)
| 2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
| 2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for
buffer
| latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID
4:2073058421:0,
| EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
| 2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
| 0x10000a, current owning EC 0x42CAC3F0.
|
| Your suggetions will be highly appreciated.
|
|
|
||||Dear Quintin,
I am just writing to see if you have had the opportunity to try the
troubleshooting steps or collect the requested information. If you have any
questions with the previous information I've provided, please don't
hesitate to let me know.
I appreciate your time and look forward to hearing from you.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| X-Tomcat-ID: 141089102
| References: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Thu, 27 Sep 2007 09:48:43 GMT
| Subject: RE: Establishing connection from SQL MMC fails
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <TcGwYuOAIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 126
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26437
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Quintin,
|
| Thank you for posting here.
|
| From the problem description, I understand that the error message
| "Establish connection to SQL Server and checking Windows security" is
| encountered when trying to connect to the SQL Server 2000 via the
| Enterprise Manage. If I have misunderstood about your concern, feel free
to
| let me know.
|
| Before moving on, I suggest that you try the following method to check if
| you could connect via osql.exe
|
| 1. Click Start, click Run, type cmd, and then click OK
| 2. At the command prompt, type the following command, and then press
ENTER.
|
|
| OSQL -E -S <server name>\<instance name>
| OSQL -E -S tcp:<computer name>,<port number>
|
| Also, you could try SQL authentication by using sa
|
| OSQL -S <server name>\<instance name> -Usa -P<password>
|
| 3. Please check if we can successfully connect to the instance of SQL
| Server 2000 by using osql.exe.
|
| If any error message appears, please let me know the extract error
message
| we received.
|
| Please also help me gather the following information for the further
| research:
|
| Information One: SQL MPS Report
| =====================| Please help create a MPSReport on the problematic machine, which will
| collect ERRORLOG, Windows event log and other helpful information about
the
| SQL Server. To create a MPSReport, please visit the following web site:
|
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
| 88B7-F9C79B7306C0&displaylang=en
|
| And look for MPSRPT_SQL.EXE. Download it and run it on the machine.
Dismiss
| the prompted dialog boxes and the readme window (usually a Notepad) after
| you read them. After the Command Prompt window closes itself, collect the
| cab file the tool has generated and sent it to me.
|
| Information Two: Screenshot
| =====================| Please also help me to capture a screenshot when the error message
| "Establish connection to SQL Server and checking Windows security"
appears.
|
| 1. When the error appears, please press the Print Screen key (PrtScn) on
| your keyboard.
| 2. Click Start, click Run, type MSPAINT, and click OK.
| 3. In Paint, click Paste under the Edit Menu, click Save under the File
| menu, type a file name for the snap shot, choose JPEG as "Save as type",
| click "Desktop" on the left pane, and click Save.
|
| Please send above files to me at v-adamqu@.microsoft.com
|
| If anything is unclear in my post, please don't hesitate to let me know
and
| I will be glad to help. Thank you for your efforts and time.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| =====================================================| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| =====================================================| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --
| | From: "Quintin Zammit" <qztarantino@.newsgroup.nospam>
| | Subject: Establishing connection from SQL MMC fails
| | Date: Wed, 26 Sep 2007 19:27:40 +0200
| | Lines: 30
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| | X-RFC2646: Format=Flowed; Original
| | Message-ID: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: 80.85.100.38
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26395
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Hi,
| |
| | I have Win2003 and SQL server 2000 installed. I have restarted SQL
| services
| | and the services crashed and could not be killed. I have killed the
| | processes manually but when I open SQL Server Enterprise Manager,
expand
| SQL
| | Server group and click on the desired SQL Server group it is failing
and
| the
| | MMC becomes not responding.
| |
| | It fails on 'Establing connection to SQL Server and checking Windows
| | security'
| |
| | I have tried to telnet on the respective SQL Server port and the port
| | responds ok. I have also done a netstat and the server is listening on
| the
| | respective port.
| |
| | From the sql error logs, the following information is being logged
| |
| | 2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in
| database
| | 'msdb' (4)
| | 2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
| | 2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for
| buffer
| | latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID
| 4:2073058421:0,
| | EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
| | 2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
| | 0x10000a, current owning EC 0x42CAC3F0.
| |
| | Your suggetions will be highly appreciated.
| |
| |
| |
| |
|
|

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
Thanks
It looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegro ups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
ThanksIt looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegroups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
ThanksIt looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegroups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

Errors-unable to start

Hello, hope someone can help. My work computer has SQL installed now and it
must be started when I need to use my network scanner then turned back off.
Why? Not sure. This has always worked fine until yesterday. When I try
to start SQL I get 3 error
messages in a row and I am hoping someone out there can let me know how to f
ix it.
I have version 8.00.760 on this computer.
* 1st pop up error:
The MSVCIRT.DLL file is linked to missing export MSVCRt.DLL:'_U@.YAPAXI@.Z
* After I click OK, 2nd error pops up:
A device attached to the system is not functioning.
* After I click OK, 3rd error pops up:
An error 31- (a device attached to the system is not functioning.) occured w
hile performing this service operation on the MSSQL Server service.
Thanks in advance..MSVCIRT.DLL file is linked to missing export MSVCRt.DLL
This may indicate that the dll is corrupt or the wrong version....have you
installed any service packs, hot fixes of other software? You can try to re
place the dll with the correct version and see if that fixes your problem...
.
Brad Feaker
Database Administrator|||I have looked at noticed that there are several different types of updates a
nd service packs, do you have a suggestion. I have not done anything as of
yet. Thanks|||Try adding any service packs and hot fixes...this looks like an OS problem a
nd the SQL Server problem is a symptom. This is an OS problem I saw - mainl
y in Win98 though....You may even want to run a repair on your OS from the
install CD if the SP's and
fixes don't replace the dll in question.
Brad Feaker
Database Administrator
Please reply to forum only!!!!
-- Roxanna wrote: --
I have looked at noticed that there are several different types of updates a
nd service packs, do you have a suggestion. I have not done anything as of
yet. Thanks

Errors-unable to start

Hello, hope someone can help. My work computer has SQL installed now and it must be started when I need to use my network scanner then turned back off. Why? Not sure. This has always worked fine until yesterday. When I try to start SQL I get 3 error
messages in a row and I am hoping someone out there can let me know how to fix it.
I have version 8.00.760 on this computer.
* 1st pop up error:
The MSVCIRT.DLL file is linked to missing export MSVCRt.DLL:?_U@.YAPAXI@.Z
* After I click OK, 2nd error pops up:
A device attached to the system is not functioning.
* After I click OK, 3rd error pops up:
An error 31- (a device attached to the system is not functioning.) occured while performing this service operation on the MSSQL Server service.
Thanks in advance..
MSVCIRT.DLL file is linked to missing export MSVCRt.DLL
This may indicate that the dll is corrupt or the wrong version....have you installed any service packs, hot fixes of other software? You can try to replace the dll with the correct version and see if that fixes your problem...
Brad Feaker
Database Administrator
|||I have looked at noticed that there are several different types of updates and service packs, do you have a suggestion. I have not done anything as of yet. Thanks
|||Try adding any service packs and hot fixes...this looks like an OS problem and the SQL Server problem is a symptom. This is an OS problem I saw - mainly in Win98 though....You may even want to run a repair on your OS from the install CD if the SP's and
fixes don't replace the dll in question.
Brad Feaker
Database Administrator
Please reply to forum only!!!!
-- Roxanna wrote: --
I have looked at noticed that there are several different types of updates and service packs, do you have a suggestion. I have not done anything as of yet. Thanks

Errors with SP4 upgrade... Please Help

I am having problems accessing DTS after install SP4 and was wondering
if someone could offer some advice.

I installed SP4 and got the following error after it competed.

Unable to write to response file 'U:\WINDOWS\setup.iss' during
recording. Please ensure enough space is available on target drive.

I got the error 3 times (3 pop-ups).

After the install I could not access DTS. I was getting 2 error
pop-ups.
1. 'rebbrui.rll is missing'
2. Snap-In failed to initialize: Meta Data Services

I read the groups and tried several things.

I tried to reinstall MDAC and it did not help.

I tried to register several dlls and it did not help.

I found this post and it seemed to help.
Repair Script:
http://www.experts-exchange.com/Dat...Q_21445589.html

I was then able to access DTS using the profile (which is an
administrator) which
I used to install SP4 and run the above repair script. However, no
other profile can open or run DTS.

I tried running the repair script under the other profiles and it did
not help.

I was receiving 2 errors for the other profiles. I only documented one
and I am no longer getting the other. Now it just goes to a white
screen and hangs.

1st error:
DTS Designer Error
The specified module could not be found.

2nd error:
???

I tried reinstalling client tools and SP4 and it did not help. Now I
get one additional error.

Before I can expand the server node in enterprise manager I get the
following error.
Snap-in failed to initialize
Name: Meta Data Services
CLSID: {1DBA4DD4-EB97-4FD2-AB80-9D0D4BA74034}

Does anyone have a suggestion on how I might fix this?

I am running SQL Server 2000 Enterprise on Windows 2000 Server with 4
GB RAM.

I did notices that someone has set the /3GB switch. I know this is not
supported on this OS but it was not causing major problems before the
upgrade. Could it be the culprit?Finally got this fixed. It was a real pain!

The registry on this server looked all hacked up to me. It looks like
many of the keys referenced U:/ instead of C:/

Some of the necessary dlls were pointing to U: also.

I had to manually uninstall SQL Server. Then reinstall. Then uninstall
via add remove programs. Then I did another uninstall/reinstall
(because i got a few errors).

I reinstalled, upgraded to sp4, stopped the service, swapped my master,
msdb, tempdb with the originals and everything is working great.

Errors with Service Pack 1

Hi Ng,
i have some problems with Rs Sp 1. I installed Sp 1 on the server and on the
pc where vs.net is installed. Now I got the following Problem:
I design a report and go to the preview mode. If an error is found, for
example a syntax problem in an expression, the report isn't displayed. No
problem till here. But now I change the expression, so that it's correct,
the report can't be displayed anyway. And from now on, the report won't show
in preview mode ever, even when the report is complete empty!!!
I deletet the report, copied the rdl code in a new one, and it could be
displayed. Renaming this report to the other name, can't be displayed...
Any Ideas?
Thanks in Advance
G. SchmelzerCould you please send me the exact steps to reproduce? I tried the following
but couldn't reproduce the issue:
1. Go to Layout view in Report Designer
2. Drop a textbox
3. Type the expression =Globals!ReportName in it
4. Preview (works fine)
5. Go back to layout.
6. Change the expression to =zzz_Globals!ReportName
7. Preview (returns an error)
8. Go back to layout.
9. Change the expression back to =Globals!ReportName
10. Preview (works fine)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"G. Schmelzer" <asdf@.de.de> wrote in message
news:OwPYh2nXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi Ng,
> i have some problems with Rs Sp 1. I installed Sp 1 on the server and on
the
> pc where vs.net is installed. Now I got the following Problem:
> I design a report and go to the preview mode. If an error is found, for
> example a syntax problem in an expression, the report isn't displayed. No
> problem till here. But now I change the expression, so that it's correct,
> the report can't be displayed anyway. And from now on, the report won't
show
> in preview mode ever, even when the report is complete empty!!!
> I deletet the report, copied the rdl code in a new one, and it could be
> displayed. Renaming this report to the other name, can't be displayed...
>
> Any Ideas?
> Thanks in Advance
> G. Schmelzer
>

errors installing SQL Server Express 2005

I've been having horrific problems installing and working with SQL Server Express 2005. I installed SSE with the Visual Web Developer tool so I assumed that the instance would synch up; but it didn't (see log contents at end) so I opened up permissions wide open to all users, and even that didn't help. I don't know for sure but I suspect that the problem probably relates to my deleting SQL Server entries from the registry and all directories and files related to it on disk. After going through the process of uninstalling and reinstalling Express 2005 numerous times, I became frustrated and decided to pull out all stops.

After reading and following all MSDN instructions and every blog and forum I could possibly locate on the subject, I could never resolve the problem of not reaching my database. I enabled all pipes and TCP/IP, etc. in the Configuration Manager, in both instances I had created; had run all command-line procedures recommended; and used cleanup programs that I could find, before reinstalling. I couldn't even get success in doing a test connection. I did get to a point where my ASP returned the message that it had connected but that the user didn't have permissions.

I think I'm destined to working with Access, which is a shame since I have encouraged students in a Web development class I teach to work with the more powerful SQL Server products. They've had success with SQL Server, so I'm setting a bad example.

Thanks in advance for help any of you can suggest.

Microsoft SQL Server 2005 Setup beginning at Sun Feb 05 23:48:08 2006
Process ID : 2036
c:\6645bd818fccc8ef0bad80e6a12f5b\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/1/5 23:48:6
Complete: LoadResourcesAction at: 2006/1/5 23:48:6, returned true
Running: ParseBootstrapOptionsAction at: 2006/1/5 23:48:6
Loaded DLL:c:\6645bd818fccc8ef0bad80e6a12f5b\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/1/5 23:48:8, returned true
Running: ValidateWinNTAction at: 2006/1/5 23:48:8
Complete: ValidateWinNTAction at: 2006/1/5 23:48:8, returned true
Running: ValidateMinOSAction at: 2006/1/5 23:48:8
Complete: ValidateMinOSAction at: 2006/1/5 23:48:8, returned true
Running: PerformSCCAction at: 2006/1/5 23:48:8
Complete: PerformSCCAction at: 2006/1/5 23:48:8, returned true
Running: ActivateLoggingAction at: 2006/1/5 23:48:8
Complete: ActivateLoggingAction at: 2006/1/5 23:48:8, returned true
Running: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8
Complete: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2036" returned false.
Running: PerformSCCAction2 at: 2006/1/5 23:48:8
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/1/5 23:48:9, returned true
Running: PerformDotNetCheck at: 2006/1/5 23:48:9
Complete: PerformDotNetCheck at: 2006/1/5 23:48:9, returned true
Running: ComponentUpdateAction at: 2006/1/5 23:48:9
Complete: ComponentUpdateAction at: 2006/1/5 23:48:30, returned true
Running: DetectLocalBootstrapAction at: 2006/1/5 23:48:30
Complete: DetectLocalBootstrapAction at: 2006/1/5 23:48:30, returned true
Running: LaunchLocalBootstrapAction at: 2006/1/5 23:48:30

To my comment "I suspect that the problem probably relates to my deleting SQL Server entries from the registry and all directories and files related to it on disk," I should append the following: "...after I uninstalled everything."

Errors installing MSDE desktop

HELP! this is driving me mad!!

I installed MSDE desktop with no problems... months later when creating a database, I stupidily forgot the "sa" password that I set during setup... So I decided to unistall MSDE and reinstall it, this time documenting the username and password... BUT now it is giving me errors which I am unable to solve... is there anyone out there that might be able to help me??

I go to a command-line, locate the directory where the install program lives and type in "setup SAPWD=(a password) SecurityMode=SQL" and it returns the follow error message:
"Setup Failed to configure the server. Refer to the server error logs and setup error logs"

My problem is I don't know where to locate these error logs. Please if anyone can help me with this problem I would greatly appreciate it.

thanks, Donald - email = pizzazzz@.cox.netPlease refer to my post in this section under the subject: "Overcoming MSDE Setup Problems". Link: http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=739042

Errors in launching Microsoft SQL Server 2005 Samples

Hi -
I just installed SS2005 all components including the workstation components
and samples etc. I go to Start -> Programs -> Microsoft SS2005 Group ->
Documentation and Tutorials -> Samples ->
Microsoft SQL Server 2005 Samples
I get: "Error 1606. Could not access network location=:."
I need to be able to launch BIDS. I do not have the short cut in Microsoft
SS2005 Program Group.
Any ideas?
Thank You-
Message posted via http://www.droptable.com
What's the Edition of your SQL Server 2005? If it's Express Edition, then
there is no BIDS in that package.
If it's Workgroup, Standard, Dev etc. then you may not be selected it from
the Components to Install window and so it may not be installed. Because its
shortcut would appear in the Microsoft SQL Server 2005 folder in the Start
menu but you say it does not appear. So something is wrong. Ensure you
installed it first.
Ekrem ?nsoy
"DotNet35-Java0 via droptable.com" <u38920@.uwe> wrote in message
news:7d090c6712e28@.uwe...
> Hi -
> I just installed SS2005 all components including the workstation
> components
> and samples etc. I go to Start -> Programs -> Microsoft SS2005 Group ->
> Documentation and Tutorials -> Samples ->
> Microsoft SQL Server 2005 Samples
> I get: "Error 1606. Could not access network location=:."
> I need to be able to launch BIDS. I do not have the short cut in Microsoft
> SS2005 Program Group.
> Any ideas?
> Thank You-
> --
> Message posted via http://www.droptable.com
>
|||Thank You for the reply. I installed SQL Server 2005 Enterprise and Applied
SP1 and SP2. I double checked by uninstalling Workstation COmponents on the
instance I had installed earlier. I went ahead and re-installed the
workstation components again. I get BIDS and everything else, but I could
not get rid of the Samples Network error
"Error 1606. Could not access network location=:." when I launch Samples
from the SS2005 Program Group.
I get the same error when trying ~/Program Files\Microsoft SQL Server 2005\90\
Tools\Samples\SQLServerSamples.msi;
I already installed all the databases manually all (AdventureWorks (OLTP),
AdventureWorksDW (data warehouse), Adventure Works DW(OLAP) sample databases),
but i am trying to figure out why this error occurs and how to get rid of it.
I need to install another instance on a different server, and I do not want
to spend the time doing things manually when the SQLServerSamples.msi should
do all that in a flash.
I appreciate any input here.
Thank You -
Ekrem ?nsoy wrote:[vbcol=seagreen]
>What's the Edition of your SQL Server 2005? If it's Express Edition, then
>there is no BIDS in that package.
>If it's Workgroup, Standard, Dev etc. then you may not be selected it from
>the Components to Install window and so it may not be installed. Because its
>shortcut would appear in the Microsoft SQL Server 2005 folder in the Start
>menu but you say it does not appear. So something is wrong. Ensure you
>installed it first.
>[quoted text clipped - 11 lines]
Message posted via http://www.droptable.com
|||When you were installing SQL Server, in the Components to Install window,
it's not enough to check "Workstation components, Books Online and
development tools". To install BIDS and sample databases you should click
the Advanced button in the same window and go to "Documentation, samples and
sample databases" click on the disk icon and select "Entire feature will be
installed on local hard drive" to make sample databases installed. And you
should be ensure BIDS is going to be installed in the same Feature Selection
window under the Client Tools.
Regarding to the error about the access to network location, where did you
download the SQLServerSamples.msi package? If you downloaded it from the
following link:
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=8389
It would be the SQL Server 2008' s samples and would be installed to the
"C:\Program Files\Microsoft SQL Server\100\Samples\" folder by default.
If the above info does not help and you already done that stuff then, I'll
ask you to tell me the problem clearer. Is your problem with the absence of
BIDS, or reaching to the content of samples that you installed using
SQLServerSamples.msi?
Also, your Operation System is Windows Server 2003, right?
Ekrem ?nsoy
"DoNet89-Java12 via droptable.com" <u38920@.uwe> wrote in message
news:7d2bee5e203de@.uwe...
> Thank You for the reply. I installed SQL Server 2005 Enterprise and
> Applied
> SP1 and SP2. I double checked by uninstalling Workstation COmponents on
> the
> instance I had installed earlier. I went ahead and re-installed the
> workstation components again. I get BIDS and everything else, but I could
> not get rid of the Samples Network error
> "Error 1606. Could not access network location=:." when I launch Samples
> from the SS2005 Program Group.
> I get the same error when trying ~/Program Files\Microsoft SQL Server
> 2005\90\
> Tools\Samples\SQLServerSamples.msi;
> I already installed all the databases manually all (AdventureWorks (OLTP),
> AdventureWorksDW (data warehouse), Adventure Works DW(OLAP) sample
> databases),
> but i am trying to figure out why this error occurs and how to get rid of
> it.
> I need to install another instance on a different server, and I do not
> want
> to spend the time doing things manually when the SQLServerSamples.msi
> should
> do all that in a flash.
> I appreciate any input here.
> Thank You -
> Ekrem ?nsoy wrote:
> --
> Message posted via http://www.droptable.com
>
|||Yes i did originally install ALL the components, and when I did re-installed
a new instance I chose Entire application and sub apps.
Then I went to the windows programs and SS 2005 >> Documentation and
tutorials>>Samples>> MS SQL Samples (English). >> I get the error.
When I reinstaled things my BIDS short cut showes up now and I can Launch
BIDS without any problems.
I did not download the SQLServerSamples.msi from anywhere. That was Included
in the dowload files from the cd. Is there a place where I can download maybe
a fesh SQLServerSamples.msi copy. Is there a chance that The SQLServerSamples.
msi is corrupt and where would I dounload the 2005 from?
Thank You -
Ekrem ?nsoy wrote:[vbcol=seagreen]
>When you were installing SQL Server, in the Components to Install window,
>it's not enough to check "Workstation components, Books Online and
>development tools". To install BIDS and sample databases you should click
>the Advanced button in the same window and go to "Documentation, samples and
>sample databases" click on the disk icon and select "Entire feature will be
>installed on local hard drive" to make sample databases installed. And you
>should be ensure BIDS is going to be installed in the same Feature Selection
>window under the Client Tools.
>Regarding to the error about the access to network location, where did you
>download the SQLServerSamples.msi package? If you downloaded it from the
>following link:
>http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=8389
>It would be the SQL Server 2008' s samples and would be installed to the
>"C:\Program Files\Microsoft SQL Server\100\Samples\" folder by default.
>If the above info does not help and you already done that stuff then, I'll
>ask you to tell me the problem clearer. Is your problem with the absence of
>BIDS, or reaching to the content of samples that you installed using
>SQLServerSamples.msi?
>Also, your Operation System is Windows Server 2003, right?
>[quoted text clipped - 38 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200712/1
|||SqlServerSamples.msi (for SQL Server 2005):
Download accordingly to your system.
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
Ekrem ?nsoy
"adaher008 via droptable.com" <u38920@.uwe> wrote in message
news:7d2d8f0931da4@.uwe...
> Yes i did originally install ALL the components, and when I did
> re-installed
> a new instance I chose Entire application and sub apps.
> Then I went to the windows programs and SS 2005 >> Documentation and
> tutorials>>Samples>> MS SQL Samples (English). >> I get the error.
> When I reinstaled things my BIDS short cut showes up now and I can Launch
> BIDS without any problems.
> I did not download the SQLServerSamples.msi from anywhere. That was
> Included
> in the dowload files from the cd. Is there a place where I can download
> maybe
> a fesh SQLServerSamples.msi copy. Is there a chance that The
> SQLServerSamples.
> msi is corrupt and where would I dounload the 2005 from?
> Thank You -
> Ekrem ?nsoy wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200712/1
>
|||Thank You - It worked. Happy Christmas.
Ekrem ?nsoy wrote:[vbcol=seagreen]
>SqlServerSamples.msi (for SQL Server 2005):
>Download accordingly to your system.
>http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
>[quoted text clipped - 46 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200712/1
|||Happy Xmas =)
Ekrem ?nsoy
"adaher008 via droptable.com" <u38920@.uwe> wrote in message
news:7d2fe34631675@.uwe...
> Thank You - It worked. Happy Christmas.
> Ekrem ?nsoy wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200712/1
>

Errors in launching Microsoft SQL Server 2005 Samples

Hi -
I just installed SS2005 all components including the workstation components
and samples etc. I go to Start -> Programs -> Microsoft SS2005 Group ->
Documentation and Tutorials -> Samples ->
Microsoft SQL Server 2005 Samples
I get: "Error 1606. Could not access network location=:."
I need to be able to launch BIDS. I do not have the short cut in Microsoft
SS2005 Program Group.
Any ideas?
Thank You-
--
Message posted via http://www.sqlmonster.comWhat's the Edition of your SQL Server 2005? If it's Express Edition, then
there is no BIDS in that package.
If it's Workgroup, Standard, Dev etc. then you may not be selected it from
the Components to Install window and so it may not be installed. Because its
shortcut would appear in the Microsoft SQL Server 2005 folder in the Start
menu but you say it does not appear. So something is wrong. Ensure you
installed it first.
--
Ekrem Ã?nsoy
"DotNet35-Java0 via SQLMonster.com" <u38920@.uwe> wrote in message
news:7d090c6712e28@.uwe...
> Hi -
> I just installed SS2005 all components including the workstation
> components
> and samples etc. I go to Start -> Programs -> Microsoft SS2005 Group ->
> Documentation and Tutorials -> Samples ->
> Microsoft SQL Server 2005 Samples
> I get: "Error 1606. Could not access network location=:."
> I need to be able to launch BIDS. I do not have the short cut in Microsoft
> SS2005 Program Group.
> Any ideas?
> Thank You-
> --
> Message posted via http://www.sqlmonster.com
>|||Thank You for the reply. I installed SQL Server 2005 Enterprise and Applied
SP1 and SP2. I double checked by uninstalling Workstation COmponents on the
instance I had installed earlier. I went ahead and re-installed the
workstation components again. I get BIDS and everything else, but I could
not get rid of the Samples Network error
"Error 1606. Could not access network location=:." when I launch Samples
from the SS2005 Program Group.
I get the same error when trying ~/Program Files\Microsoft SQL Server 2005\90\
Tools\Samples\SQLServerSamples.msi;
I already installed all the databases manually all (AdventureWorks (OLTP),
AdventureWorksDW (data warehouse), Adventure Works DW(OLAP) sample databases),
but i am trying to figure out why this error occurs and how to get rid of it.
I need to install another instance on a different server, and I do not want
to spend the time doing things manually when the SQLServerSamples.msi should
do all that in a flash.
I appreciate any input here. :)
Thank You -
Ekrem Ã?nsoy wrote:
>What's the Edition of your SQL Server 2005? If it's Express Edition, then
>there is no BIDS in that package.
>If it's Workgroup, Standard, Dev etc. then you may not be selected it from
>the Components to Install window and so it may not be installed. Because its
>shortcut would appear in the Microsoft SQL Server 2005 folder in the Start
>menu but you say it does not appear. So something is wrong. Ensure you
>installed it first.
>> Hi -
>> I just installed SS2005 all components including the workstation
>[quoted text clipped - 11 lines]
>> Thank You-
--
Message posted via http://www.sqlmonster.com|||When you were installing SQL Server, in the Components to Install window,
it's not enough to check "Workstation components, Books Online and
development tools". To install BIDS and sample databases you should click
the Advanced button in the same window and go to "Documentation, samples and
sample databases" click on the disk icon and select "Entire feature will be
installed on local hard drive" to make sample databases installed. And you
should be ensure BIDS is going to be installed in the same Feature Selection
window under the Client Tools.
Regarding to the error about the access to network location, where did you
download the SQLServerSamples.msi package? If you downloaded it from the
following link:
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=8389
It would be the SQL Server 2008' s samples and would be installed to the
"C:\Program Files\Microsoft SQL Server\100\Samples\" folder by default.
If the above info does not help and you already done that stuff then, I'll
ask you to tell me the problem clearer. Is your problem with the absence of
BIDS, or reaching to the content of samples that you installed using
SQLServerSamples.msi?
Also, your Operation System is Windows Server 2003, right?
--
Ekrem Ã?nsoy
"DoNet89-Java12 via SQLMonster.com" <u38920@.uwe> wrote in message
news:7d2bee5e203de@.uwe...
> Thank You for the reply. I installed SQL Server 2005 Enterprise and
> Applied
> SP1 and SP2. I double checked by uninstalling Workstation COmponents on
> the
> instance I had installed earlier. I went ahead and re-installed the
> workstation components again. I get BIDS and everything else, but I could
> not get rid of the Samples Network error
> "Error 1606. Could not access network location=:." when I launch Samples
> from the SS2005 Program Group.
> I get the same error when trying ~/Program Files\Microsoft SQL Server
> 2005\90\
> Tools\Samples\SQLServerSamples.msi;
> I already installed all the databases manually all (AdventureWorks (OLTP),
> AdventureWorksDW (data warehouse), Adventure Works DW(OLAP) sample
> databases),
> but i am trying to figure out why this error occurs and how to get rid of
> it.
> I need to install another instance on a different server, and I do not
> want
> to spend the time doing things manually when the SQLServerSamples.msi
> should
> do all that in a flash.
> I appreciate any input here. :)
> Thank You -
> Ekrem Ã?nsoy wrote:
>>What's the Edition of your SQL Server 2005? If it's Express Edition, then
>>there is no BIDS in that package.
>>If it's Workgroup, Standard, Dev etc. then you may not be selected it from
>>the Components to Install window and so it may not be installed. Because
>>its
>>shortcut would appear in the Microsoft SQL Server 2005 folder in the Start
>>menu but you say it does not appear. So something is wrong. Ensure you
>>installed it first.
>> Hi -
>> I just installed SS2005 all components including the workstation
>>[quoted text clipped - 11 lines]
>> Thank You-
> --
> Message posted via http://www.sqlmonster.com
>|||Yes i did originally install ALL the components, and when I did re-installed
a new instance I chose Entire application and sub apps.
Then I went to the windows programs and SS 2005 >> Documentation and
tutorials>>Samples>> MS SQL Samples (English). >> I get the error.
When I reinstaled things my BIDS short cut showes up now and I can Launch
BIDS without any problems.
I did not download the SQLServerSamples.msi from anywhere. That was Included
in the dowload files from the cd. Is there a place where I can download maybe
a fesh SQLServerSamples.msi copy. Is there a chance that The SQLServerSamples.
msi is corrupt and where would I dounload the 2005 from?
Thank You -
Ekrem Ã?nsoy wrote:
>When you were installing SQL Server, in the Components to Install window,
>it's not enough to check "Workstation components, Books Online and
>development tools". To install BIDS and sample databases you should click
>the Advanced button in the same window and go to "Documentation, samples and
>sample databases" click on the disk icon and select "Entire feature will be
>installed on local hard drive" to make sample databases installed. And you
>should be ensure BIDS is going to be installed in the same Feature Selection
>window under the Client Tools.
>Regarding to the error about the access to network location, where did you
>download the SQLServerSamples.msi package? If you downloaded it from the
>following link:
>http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=8389
>It would be the SQL Server 2008' s samples and would be installed to the
>"C:\Program Files\Microsoft SQL Server\100\Samples\" folder by default.
>If the above info does not help and you already done that stuff then, I'll
>ask you to tell me the problem clearer. Is your problem with the absence of
>BIDS, or reaching to the content of samples that you installed using
>SQLServerSamples.msi?
>Also, your Operation System is Windows Server 2003, right?
>> Thank You for the reply. I installed SQL Server 2005 Enterprise and
>> Applied
>[quoted text clipped - 38 lines]
>> Thank You-
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200712/1|||SqlServerSamples.msi (for SQL Server 2005):
Download accordingly to your system.
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
--
Ekrem Ã?nsoy
"adaher008 via SQLMonster.com" <u38920@.uwe> wrote in message
news:7d2d8f0931da4@.uwe...
> Yes i did originally install ALL the components, and when I did
> re-installed
> a new instance I chose Entire application and sub apps.
> Then I went to the windows programs and SS 2005 >> Documentation and
> tutorials>>Samples>> MS SQL Samples (English). >> I get the error.
> When I reinstaled things my BIDS short cut showes up now and I can Launch
> BIDS without any problems.
> I did not download the SQLServerSamples.msi from anywhere. That was
> Included
> in the dowload files from the cd. Is there a place where I can download
> maybe
> a fesh SQLServerSamples.msi copy. Is there a chance that The
> SQLServerSamples.
> msi is corrupt and where would I dounload the 2005 from?
> Thank You -
> Ekrem Ã?nsoy wrote:
>>When you were installing SQL Server, in the Components to Install window,
>>it's not enough to check "Workstation components, Books Online and
>>development tools". To install BIDS and sample databases you should click
>>the Advanced button in the same window and go to "Documentation, samples
>>and
>>sample databases" click on the disk icon and select "Entire feature will
>>be
>>installed on local hard drive" to make sample databases installed. And you
>>should be ensure BIDS is going to be installed in the same Feature
>>Selection
>>window under the Client Tools.
>>Regarding to the error about the access to network location, where did you
>>download the SQLServerSamples.msi package? If you downloaded it from the
>>following link:
>>http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=8389
>>It would be the SQL Server 2008' s samples and would be installed to the
>>"C:\Program Files\Microsoft SQL Server\100\Samples\" folder by default.
>>If the above info does not help and you already done that stuff then, I'll
>>ask you to tell me the problem clearer. Is your problem with the absence
>>of
>>BIDS, or reaching to the content of samples that you installed using
>>SQLServerSamples.msi?
>>Also, your Operation System is Windows Server 2003, right?
>> Thank You for the reply. I installed SQL Server 2005 Enterprise and
>> Applied
>>[quoted text clipped - 38 lines]
>> Thank You-
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200712/1
>|||Thank You - It worked. Happy Christmas.
Ekrem Ã?nsoy wrote:
>SqlServerSamples.msi (for SQL Server 2005):
>Download accordingly to your system.
>http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
>> Yes i did originally install ALL the components, and when I did
>> re-installed
>[quoted text clipped - 46 lines]
>> Thank You-
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200712/1|||Happy Xmas =)
--
Ekrem Ã?nsoy
"adaher008 via SQLMonster.com" <u38920@.uwe> wrote in message
news:7d2fe34631675@.uwe...
> Thank You - It worked. Happy Christmas.
> Ekrem Ã?nsoy wrote:
>>SqlServerSamples.msi (for SQL Server 2005):
>>Download accordingly to your system.
>>http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
>> Yes i did originally install ALL the components, and when I did
>> re-installed
>>[quoted text clipped - 46 lines]
>>>
>>> Thank You-
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200712/1
>

Errors in launching Microsoft SQL Server 2005 Samples

Hi -
I just installed SS2005 all components including the workstation components
and samples etc. I go to Start -> Programs -> Microsoft SS2005 Group ->
Documentation and Tutorials -> Samples ->
Microsoft SQL Server 2005 Samples
I get: "Error 1606. Could not access network location=:."
I need to be able to launch BIDS. I do not have the short cut in Microsoft
SS2005 Program Group.
Any ideas?
Thank You-
Message posted via http://www.droptable.comWhat's the Edition of your SQL Server 2005? If it's Express Edition, then
there is no BIDS in that package.
If it's Workgroup, Standard, Dev etc. then you may not be selected it from
the Components to Install window and so it may not be installed. Because its
shortcut would appear in the Microsoft SQL Server 2005 folder in the Start
menu but you say it does not appear. So something is wrong. Ensure you
installed it first.
Ekrem ?nsoy
"DotNet35-Java0 via droptable.com" <u38920@.uwe> wrote in message
news:7d090c6712e28@.uwe...
> Hi -
> I just installed SS2005 all components including the workstation
> components
> and samples etc. I go to Start -> Programs -> Microsoft SS2005 Group ->
> Documentation and Tutorials -> Samples ->
> Microsoft SQL Server 2005 Samples
> I get: "Error 1606. Could not access network location=:."
> I need to be able to launch BIDS. I do not have the short cut in Microsoft
> SS2005 Program Group.
> Any ideas?
> Thank You-
> --
> Message posted via http://www.droptable.com
>|||Thank You for the reply. I installed SQL Server 2005 Enterprise and Applied
SP1 and SP2. I double checked by uninstalling Workstation COmponents on the
instance I had installed earlier. I went ahead and re-installed the
workstation components again. I get BIDS and everything else, but I could
not get rid of the Samples Network error
"Error 1606. Could not access network location=:." when I launch Samples
from the SS2005 Program Group.
I get the same error when trying ~/Program Files\Microsoft SQL Server 2005\9
0\
Tools\Samples\SQLServerSamples.msi;
I already installed all the databases manually all (AdventureWorks (OLTP),
AdventureWorksDW (data warehouse), Adventure Works DW(OLAP) sample databases
),
but i am trying to figure out why this error occurs and how to get rid of it
.
I need to install another instance on a different server, and I do not want
to spend the time doing things manually when the SQLServerSamples.msi should
do all that in a flash.
I appreciate any input here.
Thank You -
Ekrem ?nsoy wrote:[vbcol=seagreen]
>What's the Edition of your SQL Server 2005? If it's Express Edition, then
>there is no BIDS in that package.
>If it's Workgroup, Standard, Dev etc. then you may not be selected it from
>the Components to Install window and so it may not be installed. Because it
s
>shortcut would appear in the Microsoft SQL Server 2005 folder in the Start
>menu but you say it does not appear. So something is wrong. Ensure you
>installed it first.
>
>[quoted text clipped - 11 lines]
Message posted via http://www.droptable.com|||When you were installing SQL Server, in the Components to Install window,
it's not enough to check "Workstation components, Books Online and
development tools". To install BIDS and sample databases you should click
the Advanced button in the same window and go to "Documentation, samples and
sample databases" click on the disk icon and select "Entire feature will be
installed on local hard drive" to make sample databases installed. And you
should be ensure BIDS is going to be installed in the same Feature Selection
window under the Client Tools.
Regarding to the error about the access to network location, where did you
download the SQLServerSamples.msi package? If you downloaded it from the
following link:
http://www.codeplex.com/SqlServerSa...Id=83
89
It would be the SQL Server 2008' s samples and would be installed to the
"C:\Program Files\Microsoft SQL Server\100\Samples\" folder by default.
If the above info does not help and you already done that stuff then, I'll
ask you to tell me the problem clearer. Is your problem with the absence of
BIDS, or reaching to the content of samples that you installed using
SQLServerSamples.msi?
Also, your Operation System is Windows Server 2003, right?
Ekrem ?nsoy
"DoNet89-Java12 via droptable.com" <u38920@.uwe> wrote in message
news:7d2bee5e203de@.uwe...
> Thank You for the reply. I installed SQL Server 2005 Enterprise and
> Applied
> SP1 and SP2. I double checked by uninstalling Workstation COmponents on
> the
> instance I had installed earlier. I went ahead and re-installed the
> workstation components again. I get BIDS and everything else, but I could
> not get rid of the Samples Network error
> "Error 1606. Could not access network location=:." when I launch Samples
> from the SS2005 Program Group.
> I get the same error when trying ~/Program Files\Microsoft SQL Server
> 2005\90\
> Tools\Samples\SQLServerSamples.msi;
> I already installed all the databases manually all (AdventureWorks (OLTP),
> AdventureWorksDW (data warehouse), Adventure Works DW(OLAP) sample
> databases),
> but i am trying to figure out why this error occurs and how to get rid of
> it.
> I need to install another instance on a different server, and I do not
> want
> to spend the time doing things manually when the SQLServerSamples.msi
> should
> do all that in a flash.
> I appreciate any input here.
> Thank You -
> Ekrem ?nsoy wrote:
> --
> Message posted via http://www.droptable.com
>|||Yes i did originally install ALL the components, and when I did re-installed
a new instance I chose Entire application and sub apps.
Then I went to the windows programs and SS 2005 >> Documentation and
tutorials>>Samples>> MS SQL Samples (English). >> I get the error.
When I reinstaled things my BIDS short cut showes up now and I can Launch
BIDS without any problems.
I did not download the SQLServerSamples.msi from anywhere. That was Included
in the dowload files from the cd. Is there a place where I can download mayb
e
a fesh SQLServerSamples.msi copy. Is there a chance that The SQLServerSample
s.
msi is corrupt and where would I dounload the 2005 from?
Thank You -
Ekrem ?nsoy wrote:[vbcol=seagreen]
>When you were installing SQL Server, in the Components to Install window,
>it's not enough to check "Workstation components, Books Online and
>development tools". To install BIDS and sample databases you should click
>the Advanced button in the same window and go to "Documentation, samples an
d
>sample databases" click on the disk icon and select "Entire feature will be
>installed on local hard drive" to make sample databases installed. And you
>should be ensure BIDS is going to be installed in the same Feature Selectio
n
>window under the Client Tools.
>Regarding to the error about the access to network location, where did you
>download the SQLServerSamples.msi package? If you downloaded it from the
>following link:
>http://www.codeplex.com/SqlServerSa...Id=8
389
>It would be the SQL Server 2008' s samples and would be installed to the
>"C:\Program Files\Microsoft SQL Server\100\Samples\" folder by default.
>If the above info does not help and you already done that stuff then, I'll
>ask you to tell me the problem clearer. Is your problem with the absence of
>BIDS, or reaching to the content of samples that you installed using
>SQLServerSamples.msi?
>Also, your Operation System is Windows Server 2003, right?
>
>[quoted text clipped - 38 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200712/1|||SqlServerSamples.msi (for SQL Server 2005):
Download accordingly to your system.
http://www.codeplex.com/SqlServerSa...Id=40
00
Ekrem ?nsoy
"adaher008 via droptable.com" <u38920@.uwe> wrote in message
news:7d2d8f0931da4@.uwe...
> Yes i did originally install ALL the components, and when I did
> re-installed
> a new instance I chose Entire application and sub apps.
> Then I went to the windows programs and SS 2005 >> Documentation and
> tutorials>>Samples>> MS SQL Samples (English). >> I get the error.
> When I reinstaled things my BIDS short cut showes up now and I can Launch
> BIDS without any problems.
> I did not download the SQLServerSamples.msi from anywhere. That was
> Included
> in the dowload files from the cd. Is there a place where I can download
> maybe
> a fesh SQLServerSamples.msi copy. Is there a chance that The
> SQLServerSamples.
> msi is corrupt and where would I dounload the 2005 from?
> Thank You -
> Ekrem ?nsoy wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200712/1
>|||Thank You - It worked. Happy Christmas.
Ekrem ?nsoy wrote:[vbcol=seagreen]
>SqlServerSamples.msi (for SQL Server 2005):
>Download accordingly to your system.
>http://www.codeplex.com/SqlServerSa...Id=4
000
>
>[quoted text clipped - 46 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200712/1|||Happy Xmas =)
Ekrem ?nsoy
"adaher008 via droptable.com" <u38920@.uwe> wrote in message
news:7d2fe34631675@.uwe...
> Thank You - It worked. Happy Christmas.
> Ekrem ?nsoy wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200712/1
>

Errors after installing Server 2000 DTS Designer Components

Hello,

After Having installed the SQL Server 2000 DTS Designer Components necessary
to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager:

"The procedure entry point
?ProcessExecute@.@.YAXPAUHWND_@.@.PBG1@.Z could not be located in teh dynamic link library SEMSFC.dll."

Is there a way to fix so that I can open Enterprise manager?

Thanks!

If you have both SQL 2000 and 2005 client tools installed, you do not need the "SQL Server 2000 DTS Designer Components" package installed.

First, uninstall them. Then figure out why 2005 is telling you to install them, when you don't need them.

Make sure you have run 2000 SP4 on your CLIENT machine to update the tools to the current version.

In my case, the error appears to be related to having SQL 7 client tools installed. When I uninstalled them the error in 2005 went away.

|||

Thanks for the info. I really appreciate it.

|||

Good info. Fixed what I thought was a very cryptic error message.

Thanks for the details!

|||

Tom,

How do you install SP4 on a client machine. How do you specify the instance and user id if I don't have one installed on my machine?

Thanks,
Joseph

Errors after installing Server 2000 DTS Designer Components

Hello,

After Having installed the SQL Server 2000 DTS Designer Components necessary
to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager:

"The procedure entry point
?ProcessExecute@.@.YAXPAUHWND_@.@.PBG1@.Z could not be located in teh dynamic link library SEMSFC.dll."

Is there a way to fix so that I can open Enterprise manager?

Thanks!

If you have both SQL 2000 and 2005 client tools installed, you do not need the "SQL Server 2000 DTS Designer Components" package installed.

First, uninstall them. Then figure out why 2005 is telling you to install them, when you don't need them.

Make sure you have run 2000 SP4 on your CLIENT machine to update the tools to the current version.

In my case, the error appears to be related to having SQL 7 client tools installed. When I uninstalled them the error in 2005 went away.

|||

Thanks for the info. I really appreciate it.

|||

Good info. Fixed what I thought was a very cryptic error message.

Thanks for the details!

|||

Tom,

How do you install SP4 on a client machine. How do you specify the instance and user id if I don't have one installed on my machine?

Thanks,
Joseph

Errors after installing Server 2000 DTS Designer Components

Hello,

After Having installed the SQL Server 2000 DTS Designer Components necessary
to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager:

"The procedure entry point
?ProcessExecute@.@.YAXPAUHWND_@.@.PBG1@.Z could not be located in teh dynamic link library SEMSFC.dll."

Is there a way to fix so that I can open Enterprise manager?

Thanks!

If you have both SQL 2000 and 2005 client tools installed, you do not need the "SQL Server 2000 DTS Designer Components" package installed.

First, uninstall them. Then figure out why 2005 is telling you to install them, when you don't need them.

Make sure you have run 2000 SP4 on your CLIENT machine to update the tools to the current version.

In my case, the error appears to be related to having SQL 7 client tools installed. When I uninstalled them the error in 2005 went away.

|||

Thanks for the info. I really appreciate it.

|||

Good info. Fixed what I thought was a very cryptic error message.

Thanks for the details!

|||

Tom,

How do you install SP4 on a client machine. How do you specify the instance and user id if I don't have one installed on my machine?

Thanks,
Joseph

Errors accessing VFP data.

I have a test system setup in Reading.
SQL Server is on machine EUK01314
IIS 5 also is on machine EUK01314
Reporting services are installed on machine EUK01314
Visual Studo is on machine EUK01314
I can create reports that access SQL server data, or via ODBC, or via OLEDB
to SQL server on EUK01314.
I can use those reports from our Terminal Server, no problem.
I can create reports that access Oracle data, via ODBC, or via OLEDB to
Oracle on a server in Belgim..
I can use those reports from our Terminal Server, no problem.
I draw a total blank accessing Visual FoxPro data.
I can create reports that access VFP data, via ODBC or OLEDB.
Those reports work on EUK01314 in Visual Studio.
Those reports work on EUK01314 in IE via Report Manager.
So why on earth (or any other planet) don't they work on any other machine
?
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
[01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Query execution failed for data set 'DataSet1'.
(rsErrorExecutingCommand) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\service.dbf.
Connection String: Provider=VFPOLEDB.1;Data
Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating Sequence=MACHINE
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Invalid path or file name.
Change to use credentials when connecting to datasource. (my user ID and
password)
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
Change to also impersonate user in Windows after connection.
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot impersonate user for data source 'DataSource1'.
(rsErrorImpersonatingUser) Get Online Help
a.. Specified method is not supported.
Remember, these work just fine when Report Manager is accessed from
EUK01314.
They do not work if Report Manager is accessed from another machine.
--
PAulHi PAul :-)
I think checking the Deleted box corresponds to SET DELETED ON which
evaluates to DELETED=YES in the connection string so be sure to verify that
you're getting what you want. Sorry I can't help on the ReportingSvcs stuff.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO|||You are using SP1, right? This looks similar to an issue that we had with
Access databases (MDBs) on remote shares. Is the FoxPro database on the same
machine as the Report Server? At one point, we were incorrectly adding an
Integrated Security property to the connection string but this should have
been fixed.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
>I have a test system setup in Reading.
> SQL Server is on machine EUK01314
> IIS 5 also is on machine EUK01314
> Reporting services are installed on machine EUK01314
> Visual Studo is on machine EUK01314
> I can create reports that access SQL server data, or via ODBC, or via
> OLEDB to SQL server on EUK01314.
> I can use those reports from our Terminal Server, no problem.
> I can create reports that access Oracle data, via ODBC, or via OLEDB to
> Oracle on a server in Belgim..
> I can use those reports from our Terminal Server, no problem.
> I draw a total blank accessing Visual FoxPro data.
> I can create reports that access VFP data, via ODBC or OLEDB.
> Those reports work on EUK01314 in Visual Studio.
> Those reports work on EUK01314 in IE via Report Manager.
> So why on earth (or any other planet) don't they work on any other machine
> ?
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
> [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
> version of ODBC behavior that the application requested (see
> SQLSetEnvAttr).
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Query execution failed for data set 'DataSet1'.
> (rsErrorExecutingCommand) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\service.dbf.
> Connection String: Provider=VFPOLEDB.1;Data
> Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating
> Sequence=MACHINE
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Invalid path or file name.
> Change to use credentials when connecting to datasource. (my user ID and
> password)
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Multiple-step OLE DB operation generated errors. Check each OLE
> DB status value, if available. No work was done.
> Change to also impersonate user in Windows after connection.
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot impersonate user for data source 'DataSource1'.
> (rsErrorImpersonatingUser) Get Online Help
> a.. Specified method is not supported.
> Remember, these work just fine when Report Manager is accessed from
> EUK01314.
> They do not work if Report Manager is accessed from another machine.
> --
> PAul
>|||Thanks Brian.
Sorry for the delay, I've been away in Utrecht.
I started out with the evaluation edition, then installed the SP1 download
onto that.
I had no errors reported during the installation of SP1, so I assume it
really completed OK.
How can I find out what the connection string being used is?
I know what I typed into the Report Manager, but you're implying that
something else is actually sent.
If there's a way to debug this, I'd like to get to the bottom of it.|||Hmm. I'm not sure there is a trace for VFP. Is it OLE DB or ODBC? For SP1,
the string should be the same (we don't add the Integrated Security flag for
other providers). You can make sure SP1 was successful by looking at the
version under http://server/reportserver.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:OZUD5Xx0EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Thanks Brian.
> Sorry for the delay, I've been away in Utrecht.
> I started out with the evaluation edition, then installed the SP1 download
> onto that.
> I had no errors reported during the installation of SP1, so I assume it
> really completed OK.
> How can I find out what the connection string being used is?
> I know what I typed into the Report Manager, but you're implying that
> something else is actually sent.
> If there's a way to debug this, I'd like to get to the bottom of it.
>|||Sorry for the delay, I've been dragged onto a BizTalk project for a while.
Microsoft SQL Server Reporting Services Version 8.00.878.00

error:no report server found on the specified machine while setting up reporting services config

Hello,

I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...

Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...

Can somebody please help me on this...

Thanks in advance...

Nirupa

Hello Nirupa,

Can you make sure you have IIS installed and running? If so, make sure you have /Reports and /ReportServer showing in IIS management.

Then, check to see if you have the following three folders in the C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services directory (where x is the component number for RS). LogFiles, ReportManager, & ReportServer

Hope this helps.

Jarret

|||

Hi Jarret,

Thanks for your suggestions first,

yes I installed IIS and it is running,

and

I couldn't find any folder C:\Program Files\Microsoft SQL Server\MSSQL.1\ Reporting Services directory

...LogFiles, ReportManager, & ReportServer

I could see only path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ Backup

'' \Bin

'' \Install

'' \LOG

'' \repldata

'' \TemplateData

can you suggest me what might had happen.... or what shall be done

Thanks

Nirupa

|||

Do you have a MSSQL.2, MSSQL.3, or MSSQL.4 folder? If so, look in each for the 3 folders I listed in my last post. If you don't have these folders, you probably should reinstall Reporting Services.

Jarret

|||

Hello Jarret

I do not have the folders that you have mentioned....As you have mentioned will probably need reinstallation

Thank you

Nirupa

|||

That is correct, if you don't have these folders, you don't have RS installed. Try to re-install and see if that fixes your problem.

Jarret

|||

Hi Jarret,

Thanks for your suggestions.As you mentioned, I reinstalled SQL reporting services and got the above mention folders(MSSQL.1,MSSQL.2,MSSQL.3) and also I successfully configured reporting services.While trying to deploy my reporting services application in to localhost , I got the below mentioned error : " The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer) "

can you please sugguest me work around for this issue.

error:25 - connection string is not valid

I have installed SQL Server 2005 Developer edition. When I open SQL Server Management Studio, and try to connect to the database engine, I enter these credentials:

Server name: LT2000\MSSQLSERVER
Login: sa
Password: my password

When I try to connect I receive the following error:
An error has occured while trying to establish a connection to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider: sql network interfaces, error:25 - connection string is not valid)(Microsoft SQL Server, Error:87)

What can I do?

Is that an error message you are seeing via a ASP.NET page trying to connect?|||

Peter Smith:

I have installed SQL Server 2005 Developer edition. When I open SQL Server Management Studio, and try to connect to the database engine, I enter these credentials:

What can I do?

I don't understand what you mean by connecting to the database engine because I have not had the need for that in 8years plus using SQL Server, but your error means you are trying to connect with only named pipes you need to use both named pipes and TCP/IP. Then enable remote connection that is covered by Microsoft below. Hope this helps.

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

|||

The surface area configuration tool used to configure SQL Serve 2005 check the doc below remote connection.

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

|||

Actually the error has nothing to do with pipes. If you look in the error message you find the message "error:25 - connection string is not valid", that is the error. If you are sure those are that is your valid credential you should use a connection string just like this one: "Data Source=LT2000\MSSQLSERVER;Initial Catalog=Northwind;User ID=sa;Password=mypassword"; Initial catalog is of course the name of your database. If that doesn't work, then use a data source wizard and enter your credentials, then test the connection and see if it works. If it doesn't you probably have wrong credentials. You can try also using the Windows Authentication('cause you set your sql server to user mixed authentication mode), in that way your connection string will be: "Data Source=LT2000\MSSQLSERVER;Initial Catalog=Northwind;Integrated Security=true".

Tell us if that works for you.

|||

Hi,

When I use MS SQL Management Studio and I want to connect, I get to see a dropdown...in this dropdown I can select "database engine".
I then fill in the type of authentication (sql server in this case), and I can log on.

I dont have the problem anymore, but that might be that out of frustration I just reinstalled SQL Server...it works fine now :)