Help with connecting to the object explorer ON Microsoft SQL Server Management Studio Expr

Hi All,

I have just installed Microsoft SQL Server Management Studio Express.. Once I did this first it was working fine, but now their is this error each time I try to connect the object explorer.. the error is as follows :-

Could not load file or assembly 'System.Data, Version=2.0.0.0, Culture=neutral publickeyToken=b77a5c561934e089' or one of its dependencies. Signature specified is zero-sized. (Exception from HRESULT: 0x80131237).

Could anybody help me with getting rid of this error. I have no clue what to do?Try closing everything, uninstall SMSS, reboot, reinstall. Make sure only necessary programs and network connections are on when you try to open SMSS again.sql

Help with Collation - Decoding the Compatibility Designator

We have a 3rd-party written application that was installed and has
been upgraded on the same server. We want to move the database to a
SAN, but it has a compatibility collation. The select
serverproperty(N'Collation') command returns:
Compatibility_52_409_20001. I have been reading about decoding this
compatibility designator, but I'm stuck. I know the 52 refers to
Dictionary Order, case-insensitive, for use with 1252 character set.
The 409 is hex 0x409 or 1033, which translates to General Unicode.
From what I've read, the 20001 is also hex which means it is 0x20001
or 131073.
Anyone have any idea what the 131073 translation is? I'd like to know
what collation sequence to choose when installing SQL 2000 to match up
with this.
Any help greatly appreciated.
Thanks,
BillThere's some more info on this in 270042 INF: Description of SQL Server
Compatibility Collations (http://support.microsoft.com/?id=270042).
Here are the bits that make up the last portion of a compatibility
collation name:
+===============+=============+==================+
| Style | Value (Hex) | Value (Decimal) |
+===============+=============+==================+
| Ignore case | 0x00001 | 1 |
+===============+=============+==================+
| Ignore accent| 0x00002 | 2 |
+===============+=============+==================+
| Ignore Kana | 0x10000 | 65536 |
+===============+=============+==================+
| Ignore width | 0x20000 | 131072 |
+===============+=============+==================+
131073 is 131072 (ignore width) + 1 (ignore case). So this collation is
accent-sensitive, kana-sensitive, case-insensitive, width-insensitive.
> I'd like to know what collation sequence to choose
> when installing SQL 2000 to match up with this.
You cannot select a compatibility collation during a clean interactive SQL
2000 setup; you can only choose one of the so-called "named collations".
Your options here are:
- Install a SQL 7.0 instance with the same collation properties and do an
in place upgrade of this instance to SQL 2000. An in-place instance
upgrade always retains the existing collation settings, even if they are
non-standard.
- Use DTS to move the data in this database to a db with a more standard
collation that you can select as an instance-level collation when
installing SQL 2K.
- Modify stored procs that join temp tables to user tables to add a
"COLLATE database_default" to the column definition of temp table
char/varchar columns. In most apps there just a handful of these
modifications are required, and one benefit of this approach is that the
app will be "system collation agnostic" from that point forward and can be
successfully run in a mixed collation evironment or on any other server.
- Do a silent install of SQL 2000. Unlike an interactive install, for a
silent install you can specify any collation name in the .ISS file, even if
it is a compatibility collation.
HTH,
Bart
--
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
From: bengels@.wi.rr.com (Bill Engels)
Newsgroups: microsoft.public.sqlserver.server
Subject: Help with Collation - Decoding the Compatibility Designator
Date: 31 Oct 2003 11:32:42 -0800
Organization: http://groups.google.com
Lines: 19
Message-ID: <7b42351f.0310311132.4c922d38@.posting.google.com>
NNTP-Posting-Host: 204.87.60.232
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1067628762 19180 127.0.0.1 (31 Oct 2003
19:32:42 GMT)
X-Complaints-To: groups-abuse@.google.com
NNTP-Posting-Date: Fri, 31 Oct 2003 19:32:42 +0000 (UTC)
Path:
cpmsftngxa06.phx.gbl!cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.su
l.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!po
stnews1.google.com!not-for-mail
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:314087
X-Tomcat-NG: microsoft.public.sqlserver.server
We have a 3rd-party written application that was installed and has
been upgraded on the same server. We want to move the database to a
SAN, but it has a compatibility collation. The select
serverproperty(N'Collation') command returns:
Compatibility_52_409_20001. I have been reading about decoding this
compatibility designator, but I'm stuck. I know the 52 refers to
Dictionary Order, case-insensitive, for use with 1252 character set.
The 409 is hex 0x409 or 1033, which translates to General Unicode.
From what I've read, the 20001 is also hex which means it is 0x20001
or 131073.
Anyone have any idea what the 131073 translation is? I'd like to know
what collation sequence to choose when installing SQL 2000 to match up
with this.
Any help greatly appreciated.
Thanks,
Bill|||Thanks for the help Bart. Appreciate the answer and ALL your help in the newsgroups.
Bill

help with activating rs

Hello,
We installed RS and got the message that we needed to activate the
reporserver. We ran the following:
c:\program files\Microsoft SQL Server\80\Tools\Binn\rsactivate -c
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
Now when the site comes up, but it is missing the Nav Bar with
contents/properties so we cannot upload any files. Is there something else
we need to run?Mayby you're loged on with a user that hasn't got any rights. Use
administrator login to give the initial access-rigths.
"Jake Smythe" wrote:
> Hello,
> We installed RS and got the message that we needed to activate the
> reporserver. We ran the following:
> c:\program files\Microsoft SQL Server\80\Tools\Binn\rsactivate -c
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Now when the site comes up, but it is missing the Nav Bar with
> contents/properties so we cannot upload any files. Is there something else
> we need to run?
>
>|||Antoon,
We are logged into a user that is part of the administrators group. Any
other ideas?
Jake
"Antoon" <Antoon@.discussions.microsoft.com> wrote in message
news:CBAF4E9E-AD80-49AE-9E6C-209E977BC4EA@.microsoft.com...
> Mayby you're loged on with a user that hasn't got any rights. Use
> administrator login to give the initial access-rigths.
> "Jake Smythe" wrote:
>> Hello,
>> We installed RS and got the message that we needed to activate the
>> reporserver. We ran the following:
>> c:\program files\Microsoft SQL Server\80\Tools\Binn\rsactivate -c
>> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportServer\RSReportServer.config"
>> Now when the site comes up, but it is missing the Nav Bar with
>> contents/properties so we cannot upload any files. Is there something
>> else
>> we need to run?
>>

help with accessing reportserver with web browser

I am using sql express w/ advanced services on xp pro with IIS 5.1 installed. On the local machine named 'Tester' i am able to access reportserver using a web browser and the url: http://localhost/reportserver. But when i go to another machine on the same network and domain and try to access the reportserver with url: http://Tester.domain/reportserver or http://<ip address of Tester>/reportserver ie tells me page cannot be found and does not give me any errors. How do I set up network access to reportserver on the machine Tester? Help would be greaty appreciated.

Try and turn off Windows Firewall to see if that helps.

To troubleshoot, you should be able to telnet to port 80 from the other machine.

cheers,

Andrew

Help w/ installing SW on SQL server (2005).

I have a server that has SQL server 2005 installed. I am trying to install additional sw and there seems to be a password algorithm set by our network that is too advanced for the sw i am trying to install. I get a error message stating "password to short" and "password doesnt meet complexity requirements".

Does anyone know if there is a way to turn off, disable or bypass the password algorithm?

Thanks!If I understand you correctly...the password complexity checkbox is in the properties of the login (user) you are trying to use. Open the default instance on your server, expand the security folder and click on the logins folder. Right click the user you are attempting to login with and select properties. In the middle of the properties page you will see 3 check boxes with the options you are seeking. Hope this is what you needed.

Help SP3a installation error

I have just installed a new Win2000 server, and loaded
SQL2000 Standard Edition. As soon as I try to install sp3a
I get the following error:
"Setup Initialization error.
Access is denied.
Source: D:\installs\SP3a-SQL2000\x86\setup\sqlspre.ini
Target: ...path\temp\setupsql.ini"
I am running the installation as administrator.| I have just installed a new Win2000 server, and loaded
| SQL2000 Standard Edition. As soon as I try to install sp3a
| I get the following error:
| "Setup Initialization error.
| Access is denied.
| Source: D:\installs\SP3a-SQL2000\x86\setup\sqlspre.ini
| Target: ...path\temp\setupsql.ini"
|
| I am running the installation as administrator.
--
Hi Sean,
Check c:\winnt\temp folder and see if setupsql.ini already exists. If it
does,
delete it. This should allow setupsql to complete successfully.
Hope this helps,
--
Eric Cárdenas
SQL Server support

HELP recovering from .Net 1.1 SP1 install

Report server has been failing on my machine ever since I installed the .Net
framework 1.1 SP1 to correct another problem. The error reported was that the
encryption keys were not working. Based on previous posts to solve this
problem I performed the following staps:
1. I ran rskeymgmt -d to delete the encrypted data.
2. restarted IIS
3. ran rsconfig with the following options
rsconfig -c -s <myserver> -d ReportServer -a Windows
rsconfig -c -s <myserver> -d ReportServerTempDB -a Windows
rsconfig -c -s <server> -d <database> -a Sql -u <username> -p
<password>
The above commands completed successfully
4. I tried to run rsactivate -r -c RSReportServer.config, but it responded
that the web service is already in a valid state or its state cannot be
determined.
When I try to access the report manager, I receive the following error:
The version of the report server database is either in a format that is
not valid, or it cannot be read. The found version is 'T.0.6.51'. The
expected version is 'C.0.6.51'.
I do not know what to try at this point other than trying to reinstall
report server, but from other posts it appears that a reinstall doesn't
always fix the problem.run rsconfig only once using the ReportServer database name. The temp
database name is always derived from the reportserver db name and you do not
need to use RSConfig to tell RS about the tempdb name.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jbmeeh" <jbmeeh@.discussions.microsoft.com> wrote in message
news:4C7D2D20-F6B5-4616-8476-265FCC42E045@.microsoft.com...
> Report server has been failing on my machine ever since I installed the
.Net
> framework 1.1 SP1 to correct another problem. The error reported was that
the
> encryption keys were not working. Based on previous posts to solve this
> problem I performed the following staps:
> 1. I ran rskeymgmt -d to delete the encrypted data.
> 2. restarted IIS
> 3. ran rsconfig with the following options
> rsconfig -c -s <myserver> -d ReportServer -a Windows
> rsconfig -c -s <myserver> -d ReportServerTempDB -a Windows
> rsconfig -c -s <server> -d <database> -a Sql -u <username> -p
> <password>
> The above commands completed successfully
> 4. I tried to run rsactivate -r -c RSReportServer.config, but it responded
> that the web service is already in a valid state or its state cannot be
> determined.
> When I try to access the report manager, I receive the following error:
> The version of the report server database is either in a format that
is
> not valid, or it cannot be read. The found version is 'T.0.6.51'. The
> expected version is 'C.0.6.51'.
> I do not know what to try at this point other than trying to reinstall
> report server, but from other posts it appears that a reinstall doesn't
> always fix the problem.
>|||What do I do at this point?
"Daniel Reib [MSFT]" wrote:
> run rsconfig only once using the ReportServer database name. The temp
> database name is always derived from the reportserver db name and you do not
> need to use RSConfig to tell RS about the tempdb name.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jbmeeh" <jbmeeh@.discussions.microsoft.com> wrote in message
> news:4C7D2D20-F6B5-4616-8476-265FCC42E045@.microsoft.com...
> > Report server has been failing on my machine ever since I installed the
> ..Net
> > framework 1.1 SP1 to correct another problem. The error reported was that
> the
> > encryption keys were not working. Based on previous posts to solve this
> > problem I performed the following staps:
> >
> > 1. I ran rskeymgmt -d to delete the encrypted data.
> > 2. restarted IIS
> > 3. ran rsconfig with the following options
> >
> > rsconfig -c -s <myserver> -d ReportServer -a Windows
> > rsconfig -c -s <myserver> -d ReportServerTempDB -a Windows
> > rsconfig -c -s <server> -d <database> -a Sql -u <username> -p
> > <password>
> > The above commands completed successfully
> > 4. I tried to run rsactivate -r -c RSReportServer.config, but it responded
> > that the web service is already in a valid state or its state cannot be
> > determined.
> >
> > When I try to access the report manager, I receive the following error:
> >
> > The version of the report server database is either in a format that
> is
> > not valid, or it cannot be read. The found version is 'T.0.6.51'. The
> > expected version is 'C.0.6.51'.
> >
> > I do not know what to try at this point other than trying to reinstall
> > report server, but from other posts it appears that a reinstall doesn't
> > always fix the problem.
> >
>
>|||First decide if you are going to use windows auth or SQL auth. Then run
rsconfig passing in ReportServer for the -d option your choice for -a -u
and -p.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jbmeeh" <jbmeeh@.discussions.microsoft.com> wrote in message
news:71D5A499-F838-4507-A64F-D6F6884B3118@.microsoft.com...
> What do I do at this point?
> "Daniel Reib [MSFT]" wrote:
> > run rsconfig only once using the ReportServer database name. The temp
> > database name is always derived from the reportserver db name and you do
not
> > need to use RSConfig to tell RS about the tempdb name.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "jbmeeh" <jbmeeh@.discussions.microsoft.com> wrote in message
> > news:4C7D2D20-F6B5-4616-8476-265FCC42E045@.microsoft.com...
> > > Report server has been failing on my machine ever since I installed
the
> > ..Net
> > > framework 1.1 SP1 to correct another problem. The error reported was
that
> > the
> > > encryption keys were not working. Based on previous posts to solve
this
> > > problem I performed the following staps:
> > >
> > > 1. I ran rskeymgmt -d to delete the encrypted data.
> > > 2. restarted IIS
> > > 3. ran rsconfig with the following options
> > >
> > > rsconfig -c -s <myserver> -d ReportServer -a Windows
> > > rsconfig -c -s <myserver> -d ReportServerTempDB -a Windows
> > > rsconfig -c -s <server> -d <database> -a Sql -u <username> -p
> > > <password>
> > > The above commands completed successfully
> > > 4. I tried to run rsactivate -r -c RSReportServer.config, but it
responded
> > > that the web service is already in a valid state or its state cannot
be
> > > determined.
> > >
> > > When I try to access the report manager, I receive the following
error:
> > >
> > > The version of the report server database is either in a format
that
> > is
> > > not valid, or it cannot be read. The found version is 'T.0.6.51'. The
> > > expected version is 'C.0.6.51'.
> > >
> > > I do not know what to try at this point other than trying to reinstall
> > > report server, but from other posts it appears that a reinstall
doesn't
> > > always fix the problem.
> > >
> >
> >
> >|||I gave up trying rebuild the encrypted data. I couldn't get around the
problem of the database version being incorrect. I reinstalled report server
and that cleared up the problem.
"Daniel Reib [MSFT]" wrote:
> First decide if you are going to use windows auth or SQL auth. Then run
> rsconfig passing in ReportServer for the -d option your choice for -a -u
> and -p.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jbmeeh" <jbmeeh@.discussions.microsoft.com> wrote in message
> news:71D5A499-F838-4507-A64F-D6F6884B3118@.microsoft.com...
> > What do I do at this point?
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > run rsconfig only once using the ReportServer database name. The temp
> > > database name is always derived from the reportserver db name and you do
> not
> > > need to use RSConfig to tell RS about the tempdb name.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "jbmeeh" <jbmeeh@.discussions.microsoft.com> wrote in message
> > > news:4C7D2D20-F6B5-4616-8476-265FCC42E045@.microsoft.com...
> > > > Report server has been failing on my machine ever since I installed
> the
> > > ..Net
> > > > framework 1.1 SP1 to correct another problem. The error reported was
> that
> > > the
> > > > encryption keys were not working. Based on previous posts to solve
> this
> > > > problem I performed the following staps:
> > > >
> > > > 1. I ran rskeymgmt -d to delete the encrypted data.
> > > > 2. restarted IIS
> > > > 3. ran rsconfig with the following options
> > > >
> > > > rsconfig -c -s <myserver> -d ReportServer -a Windows
> > > > rsconfig -c -s <myserver> -d ReportServerTempDB -a Windows
> > > > rsconfig -c -s <server> -d <database> -a Sql -u <username> -p
> > > > <password>
> > > > The above commands completed successfully
> > > > 4. I tried to run rsactivate -r -c RSReportServer.config, but it
> responded
> > > > that the web service is already in a valid state or its state cannot
> be
> > > > determined.
> > > >
> > > > When I try to access the report manager, I receive the following
> error:
> > > >
> > > > The version of the report server database is either in a format
> that
> > > is
> > > > not valid, or it cannot be read. The found version is 'T.0.6.51'. The
> > > > expected version is 'C.0.6.51'.
> > > >
> > > > I do not know what to try at this point other than trying to reinstall
> > > > report server, but from other posts it appears that a reinstall
> doesn't
> > > > always fix the problem.
> > > >
> > >
> > >
> > >
>
>