Cant find SQL Server Management Studio

I can't find theSQL Server Management Studio anywhere. I've installed SQL server 2005 developer edition and choosed every component from the list but it isn't in the start->program->SQL server 2005 menu, there's only a couple of configuration managers.

Where can I find it, or am I missing something?

Copy all the files to your hard drive and rerun setup and choose repair to select all components management studio is under management tools. And I don't know what the configuration managers do but they are not related to management studio. Hope this helps.

|||

or, tryhttp://www.microsoft.com/downloads/details.aspx?familyid=57856CDD-DA9B-4AD0-9A8A-F193AE8410AD&displaylang=en#filelist

where I googled it. Seems as it doesn't install in some packages of SQLExpress.

hope this helps. - itagens

Cant find SMSS

After installing the evaluation edition of MSSQL Enterprise 2005 I can not find SSMS. I know I installed the client tools upon installation. It's not showing up on in the menu, where is the location for the executable file.

Is SSMS even distriubted with the evaluation edition?

If not, is it possible to download it from somwhere...

Did you get any warnings while setup cheked your computer configuration?

Did you specify client tools installation during setup?

P.S. This question suits http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 forum better.

|||

SSMS is part of the evaluation edition. To see a report of what's installed go to Add/Remove Programs, select the entry for "Microsoft SQL Server 2005", select "Change", then select "Report". Under "Common Components" you'll want to see something like this:

Workstation Components
[Version: 9.00.1399.06 Edition: Evaluation Edition Patch level: 9.00.1399.06 Language: English (United States)]

If you see this and still don't think you have SSMS installed, close the report. On the "Change" dialog you should see an entry for Workstation Components, select it and press "Next". This will launch the component in maintenance mode. Just follow the dialogs. When you get to the feature tree be sure to select Management Tools under the Client Components node.

SSMS is installed to %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlwb.exe

|||Thanks for your reply::

I got the evauation to work when I downloaded the DVD image and burnt it to disk, and did a fresh install...

I'm now in the process of converting my MySQL talbles over to MSSQL... weeee fun... SSIS takes some of the headake away!|||Excellent!

Can't find Reporting Service?

I wanted to add Reports Service to my sql express. I downloaded the SQLEXPR_ADV.EXE and also Edition Toolkit SP1. But can't see the option to install Report service.

Any help please.

Juvan

Reporting Services is included with SQL Express Advanced. Launch this installer and you will see an option to install it during the "Feature Selection" dialog.

Thanks,
Sam Lester (MSFT)

Can't find Reporting Service?

I wanted to add Reports Service to my sql express. I downloaded the SQLEXPR_ADV.EXE and also Edition Toolkit SP1. But can't see the option to install Report service.

Any help please.

Juvan

Reporting Services is included with SQL Express Advanced. Launch this installer and you will see an option to install it during the "Feature Selection" dialog.

Thanks,
Sam Lester (MSFT)

Can't find Report Builder

I've installed SQL Server 2005 Developer Edition along with Visual Studio 2005. The SQL management consol indicates that Reporting Services is running, but I can't seem to find the Report Builder for the life of me. Is it integrated into Visual Studio somewhere?Report Builder is a ClickOnce app that is installed and run from the web. If you go to the web interface for SSRS you should see a button towards the top of the web page that will launch Report Builder.sql

Cant Find MS SQL SERVER in DataSource

hi..

i am using C# eXpress edition 2005..and i have downloaded the SQL Express Edition..

the problem is that i cant find "Microsoft SQL Server" in data sources..

there are only two items listed

-> Microsoft Access DataBase File

-> Microsoft SQL Server Database File

Where do i get "Microsoft SQL Server" ?

hi,

Visual Studio Express editions designers are "designed" to use only "file based" connections and thus User Instances features... you can connect to the "traditional" SQLExpress engine, but only by code and not via the designers..

regards

|||thankXX a lot mate..

Can't find Microsoft.ReportingServices.ReportRendering assembly

Hi,
I have installed Microsoft SQL Server 2000 Reporting services
Evaluation Edition. I am trying to wrtie a custom rendering service.
But to implement the
IRenderingExtension interface i need to reference
Microsoft.ReportingServices.ReportRendering assembly. I am unable to
find it any of the installed directories. Can you please tell me how
to go about this?
Any help will be appreciated.
Regards
VijaykumarHi,
I don't think such a file exists.
You have specific dlls for rendering extensiosn for example :
Microsoft.reportingservices.excelrendering,
Microsoft.reportingservices.csvrendering.
You don't have a dll for a report rendering. Reports are rendered through
rendering extensions (excel, pdf, csv, etc...
Cédric
"Vijaykumar" <vijaykumarkarekar@.hotmail.com> wrote in message
news:63da8fe5.0408152338.88b9e0b@.posting.google.com...
> Hi,
> I have installed Microsoft SQL Server 2000 Reporting services
> Evaluation Edition. I am trying to wrtie a custom rendering service.
> But to implement the
> IRenderingExtension interface i need to reference
> Microsoft.ReportingServices.ReportRendering assembly. I am unable to
> find it any of the installed directories. Can you please tell me how
> to go about this?
> Any help will be appreciated.
> Regards
> Vijaykumar|||Hi Vijaykumar:
The type IRenderingExtension exists in the
Microsoft.ReportingServices.ReportRendering *namespace*.
The assembly for the type is actually
Microsoft.ReportingServices.Processing.dll.
HTH,
--
Scott
http://www.OdeToCode.com
On 16 Aug 2004 00:38:26 -0700, vijaykumarkarekar@.hotmail.com
(Vijaykumar) wrote:
>Hi,
>I have installed Microsoft SQL Server 2000 Reporting services
>Evaluation Edition. I am trying to wrtie a custom rendering service.
>But to implement the
>IRenderingExtension interface i need to reference
>Microsoft.ReportingServices.ReportRendering assembly. I am unable to
>find it any of the installed directories. Can you please tell me how
>to go about this?
>Any help will be appreciated.
>Regards
>Vijaykumar|||You need to reference the ReportRendering namespace, which is contained in
the same assembly as the ReportProcessing namespace:
Microsoft.ReportingServices.Processing.dll
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vijaykumar" <vijaykumarkarekar@.hotmail.com> wrote in message
news:63da8fe5.0408152338.88b9e0b@.posting.google.com...
> Hi,
> I have installed Microsoft SQL Server 2000 Reporting services
> Evaluation Edition. I am trying to wrtie a custom rendering service.
> But to implement the
> IRenderingExtension interface i need to reference
> Microsoft.ReportingServices.ReportRendering assembly. I am unable to
> find it any of the installed directories. Can you please tell me how
> to go about this?
> Any help will be appreciated.
> Regards
> Vijaykumar|||"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message news:<#uOoZ$5gEHA.1656@.TK2MSFTNGP09.phx.gbl>...
> You need to reference the ReportRendering namespace, which is contained in
> the same assembly as the ReportProcessing namespace:
> Microsoft.ReportingServices.Processing.dll
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Vijaykumar" <vijaykumarkarekar@.hotmail.com> wrote in message
> news:63da8fe5.0408152338.88b9e0b@.posting.google.com...
> > Hi,
> > I have installed Microsoft SQL Server 2000 Reporting services
> > Evaluation Edition. I am trying to wrtie a custom rendering service.
> > But to implement the
> > IRenderingExtension interface i need to reference
> > Microsoft.ReportingServices.ReportRendering assembly. I am unable to
> > find it any of the installed directories. Can you please tell me how
> > to go about this?
> >
> > Any help will be appreciated.
> >
> > Regards
> > Vijaykumar
Thnaks Robert I got it. Let me try to implement the custom rendering.

can't find maintenance plan wizard in MSS2005

Hello,
I use sql server 2005 standard edition, sp1 installed on win2003server.
I can't find the maintenance plan wizard in the object explorer in the
management-studio.
In documentation I found out, that the user connection must be done via
windows authentication and you have to
be a role-member of sysadmin (what does this mean exactly?).
Furthermore databases must have a compatibility of 80 (MSS2000) or
higher.
I met all conditions, but I still can't use the wizard.
Any ideas how to make the wizard 'visible' or is there a command line
statement to call it?
Thanks for any help!In SSMS open Management and right click on Maintenance Plans. The
second options is the manitenance plan wizard.
Markus|||MarkusB wrote:
> In SSMS open Management and right click on Maintenance Plans. The
> second options is the manitenance plan wizard.
> Markus
Already the item 'Maintenance Plans' under Management is missing !!!
Only under the subitem Legacy there is a item 'Database Maintenance
Plans'.
But rightclicking there doesn't show the wizard-item.
anymore ideas?|||keltchen wrote on 7 Aug 2006 03:58:42 -0700:

> MarkusB wrote:
> Already the item 'Maintenance Plans' under Management is missing !!!
> Only under the subitem Legacy there is a item 'Database Maintenance
> Plans'.
> But rightclicking there doesn't show the wizard-item.
> anymore ideas?
You did what I did - didn't install SQL Server Integration Services. The
Maintenance Plan Wizard (and the interface to plans from SMSS) is part of
SSIS. Install SSIS from the SQL Server CD and you should get it working.
Dan

can't find maintenance plan wizard in MSS2005

Hello,
I use sql server 2005 standard edition, sp1 installed on win2003server.
I can't find the maintenance plan wizard in the object explorer in the
management-studio.
In documentation I found out, that the user connection must be done via
windows authentication and you have to
be a role-member of sysadmin (what does this mean exactly?).
Furthermore databases must have a compatibility of 80 (MSS2000) or
higher.
I met all conditions, but I still can't use the wizard.
Any ideas how to make the wizard 'visible' or is there a command line
statement to call it?
Thanks for any help!In SSMS open Management and right click on Maintenance Plans. The
second options is the manitenance plan wizard.
Markus|||MarkusB wrote:
> In SSMS open Management and right click on Maintenance Plans. The
> second options is the manitenance plan wizard.
> Markus
Already the item 'Maintenance Plans' under Management is missing !!!
Only under the subitem Legacy there is a item 'Database Maintenance
Plans'.
But rightclicking there doesn't show the wizard-item.
anymore ideas?|||keltchen wrote on 7 Aug 2006 03:58:42 -0700:
> MarkusB wrote:
>> In SSMS open Management and right click on Maintenance Plans. The
>> second options is the manitenance plan wizard.
>> Markus
> Already the item 'Maintenance Plans' under Management is missing !!!
> Only under the subitem Legacy there is a item 'Database Maintenance
> Plans'.
> But rightclicking there doesn't show the wizard-item.
> anymore ideas?
You did what I did - didn't install SQL Server Integration Services. The
Maintenance Plan Wizard (and the interface to plans from SMSS) is part of
SSIS. Install SSIS from the SQL Server CD and you should get it working.
Dan

Can't create partitioned table in Developer Edition?

I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
fails saying that partitioned tables may only be created in Enterprise
Edition. What gives, DE is supposed to have all the capabilities of EE?
Scott
On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
> fails saying that partitioned tables may only be created in Enterprise
> Edition. What gives, DE is supposed to have all the capabilities of EE?
> Scott
I have no problem on a developer edition
What does this return?
select serverproperty('Edition')
I have no problem running the following on a developer edition
CREATE PARTITION FUNCTION pf_Range (int)
AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
GO
CREATE TABLE TestPartition (id int not null)
INSERT TestPartition VALUES(1)
INSERT TestPartition VALUES(2)
INSERT TestPartition VALUES(3)
INSERT TestPartition VALUES(10)
INSERT TestPartition VALUES(11)
INSERT TestPartition VALUES(17)
INSERT TestPartition VALUES(18)
INSERT TestPartition VALUES(19)
INSERT TestPartition VALUES(21)
INSERT TestPartition VALUES(25)
INSERT TestPartition VALUES(22)
INSERT TestPartition VALUES(23)
INSERT TestPartition VALUES(0)
INSERT TestPartition VALUES(5)
GO
CREATE PARTITION SCHEME ps_Range
AS PARTITION pf_Range
ALL TO ([PRIMARY])
GO
CREATE CLUSTERED INDEX IX_TestPartition_ID
ON TestPartition(ID) ON ps_Range(ID)
SELECT $PARTITION.pf_Range(ID) AS Partition,*
FROM TestPartition
ORDER BY Partition
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||That's interesting, it returns 'Standard Edition'. I thought I downloaded DE
with my MDSN subscription. I'll go back through the process to see where I
went wrong.
Thanks.
"SQL Menace" wrote:

> On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I have no problem on a developer edition
> What does this return?
> select serverproperty('Edition')
> I have no problem running the following on a developer edition
> CREATE PARTITION FUNCTION pf_Range (int)
> AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
> GO
>
> CREATE TABLE TestPartition (id int not null)
> INSERT TestPartition VALUES(1)
> INSERT TestPartition VALUES(2)
> INSERT TestPartition VALUES(3)
> INSERT TestPartition VALUES(10)
> INSERT TestPartition VALUES(11)
> INSERT TestPartition VALUES(17)
> INSERT TestPartition VALUES(18)
> INSERT TestPartition VALUES(19)
> INSERT TestPartition VALUES(21)
> INSERT TestPartition VALUES(25)
> INSERT TestPartition VALUES(22)
> INSERT TestPartition VALUES(23)
> INSERT TestPartition VALUES(0)
> INSERT TestPartition VALUES(5)
> GO
>
> CREATE PARTITION SCHEME ps_Range
> AS PARTITION pf_Range
> ALL TO ([PRIMARY])
> GO
>
> CREATE CLUSTERED INDEX IX_TestPartition_ID
> ON TestPartition(ID) ON ps_Range(ID)
>
> SELECT $PARTITION.pf_Range(ID) AS Partition,*
> FROM TestPartition
> ORDER BY Partition
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>

Can't create partitioned table in Developer Edition?

I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
fails saying that partitioned tables may only be created in Enterprise
Edition. What gives, DE is supposed to have all the capabilities of EE?
ScottOn Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
> fails saying that partitioned tables may only be created in Enterprise
> Edition. What gives, DE is supposed to have all the capabilities of EE?
> Scott
I have no problem on a developer edition
What does this return?
select serverproperty('Edition')
I have no problem running the following on a developer edition
CREATE PARTITION FUNCTION pf_Range (int)
AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
GO
CREATE TABLE TestPartition (id int not null)
INSERT TestPartition VALUES(1)
INSERT TestPartition VALUES(2)
INSERT TestPartition VALUES(3)
INSERT TestPartition VALUES(10)
INSERT TestPartition VALUES(11)
INSERT TestPartition VALUES(17)
INSERT TestPartition VALUES(18)
INSERT TestPartition VALUES(19)
INSERT TestPartition VALUES(21)
INSERT TestPartition VALUES(25)
INSERT TestPartition VALUES(22)
INSERT TestPartition VALUES(23)
INSERT TestPartition VALUES(0)
INSERT TestPartition VALUES(5)
GO
CREATE PARTITION SCHEME ps_Range
AS PARTITION pf_Range
ALL TO ([PRIMARY])
GO
CREATE CLUSTERED INDEX IX_TestPartition_ID
ON TestPartition(ID) ON ps_Range(ID)
SELECT $PARTITION.pf_Range(ID) AS Partition,*
FROM TestPartition
ORDER BY Partition
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||That's interesting, it returns 'Standard Edition'. I thought I downloaded DE
with my MDSN subscription. I'll go back through the process to see where I
went wrong.
Thanks.
"SQL Menace" wrote:
> On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> > I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
> > fails saying that partitioned tables may only be created in Enterprise
> > Edition. What gives, DE is supposed to have all the capabilities of EE?
> >
> > Scott
> I have no problem on a developer edition
> What does this return?
> select serverproperty('Edition')
> I have no problem running the following on a developer edition
> CREATE PARTITION FUNCTION pf_Range (int)
> AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
> GO
>
> CREATE TABLE TestPartition (id int not null)
> INSERT TestPartition VALUES(1)
> INSERT TestPartition VALUES(2)
> INSERT TestPartition VALUES(3)
> INSERT TestPartition VALUES(10)
> INSERT TestPartition VALUES(11)
> INSERT TestPartition VALUES(17)
> INSERT TestPartition VALUES(18)
> INSERT TestPartition VALUES(19)
> INSERT TestPartition VALUES(21)
> INSERT TestPartition VALUES(25)
> INSERT TestPartition VALUES(22)
> INSERT TestPartition VALUES(23)
> INSERT TestPartition VALUES(0)
> INSERT TestPartition VALUES(5)
> GO
>
> CREATE PARTITION SCHEME ps_Range
> AS PARTITION pf_Range
> ALL TO ([PRIMARY])
> GO
>
> CREATE CLUSTERED INDEX IX_TestPartition_ID
> ON TestPartition(ID) ON ps_Range(ID)
>
> SELECT $PARTITION.pf_Range(ID) AS Partition,*
> FROM TestPartition
> ORDER BY Partition
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>

Can't create partitioned table in Developer Edition?

I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
fails saying that partitioned tables may only be created in Enterprise
Edition. What gives, DE is supposed to have all the capabilities of EE?
ScottOn Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I'm trying to create a partitioned table in SQL2K5 Developer Edition and i
t
> fails saying that partitioned tables may only be created in Enterprise
> Edition. What gives, DE is supposed to have all the capabilities of EE?
> Scott
I have no problem on a developer edition
What does this return?
select serverproperty('Edition')
I have no problem running the following on a developer edition
CREATE PARTITION FUNCTION pf_Range (int)
AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
GO
CREATE TABLE TestPartition (id int not null)
INSERT TestPartition VALUES(1)
INSERT TestPartition VALUES(2)
INSERT TestPartition VALUES(3)
INSERT TestPartition VALUES(10)
INSERT TestPartition VALUES(11)
INSERT TestPartition VALUES(17)
INSERT TestPartition VALUES(18)
INSERT TestPartition VALUES(19)
INSERT TestPartition VALUES(21)
INSERT TestPartition VALUES(25)
INSERT TestPartition VALUES(22)
INSERT TestPartition VALUES(23)
INSERT TestPartition VALUES(0)
INSERT TestPartition VALUES(5)
GO
CREATE PARTITION SCHEME ps_Range
AS PARTITION pf_Range
ALL TO ([PRIMARY])
GO
CREATE CLUSTERED INDEX IX_TestPartition_ID
ON TestPartition(ID) ON ps_Range(ID)
SELECT $PARTITION.pf_Range(ID) AS Partition,*
FROM TestPartition
ORDER BY Partition
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||That's interesting, it returns 'Standard Edition'. I thought I downloaded DE
with my MDSN subscription. I'll go back through the process to see where I
went wrong.
Thanks.
"SQL Menace" wrote:

> On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I have no problem on a developer edition
> What does this return?
> select serverproperty('Edition')
> I have no problem running the following on a developer edition
> CREATE PARTITION FUNCTION pf_Range (int)
> AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
> GO
>
> CREATE TABLE TestPartition (id int not null)
> INSERT TestPartition VALUES(1)
> INSERT TestPartition VALUES(2)
> INSERT TestPartition VALUES(3)
> INSERT TestPartition VALUES(10)
> INSERT TestPartition VALUES(11)
> INSERT TestPartition VALUES(17)
> INSERT TestPartition VALUES(18)
> INSERT TestPartition VALUES(19)
> INSERT TestPartition VALUES(21)
> INSERT TestPartition VALUES(25)
> INSERT TestPartition VALUES(22)
> INSERT TestPartition VALUES(23)
> INSERT TestPartition VALUES(0)
> INSERT TestPartition VALUES(5)
> GO
>
> CREATE PARTITION SCHEME ps_Range
> AS PARTITION pf_Range
> ALL TO ([PRIMARY])
> GO
>
> CREATE CLUSTERED INDEX IX_TestPartition_ID
> ON TestPartition(ID) ON ps_Range(ID)
>
> SELECT $PARTITION.pf_Range(ID) AS Partition,*
> FROM TestPartition
> ORDER BY Partition
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>

Can't create Merge Publication

I have been trying for some time to create a Merge publication in SQL Server. I'm running SQL Server 2000 Standard Edition with the latest service pack on a Win2k3 Server. It doesn't seem to matter what replication-enabled database or which table I select
, I always get the same error at the end of the create publication wizard in Enterprise Mgr: "Error 2758 RAISERROR could not locate entry for error 21423 in sysmessages. Object 'pubs' (note: or whatever db I select) does not exist or is not a valid object
for this operation."
Any ideas here?
Corey - possibly this is an incomplete service pack install as some messages
in sysmessages are missing. You could have a look at sqlsp.log file from the
c:\windows directory which might shed some light on any failed actions
during the sp installation. Even if there isn't anything enlightening there
I'd reapply the sp3a.
HTH,
Paul Ibison
|||Thanks, Paul, but so far no luck. I dug through the log and didn't find anything all that revealing. I also re-applied SP3a, but that didn't help either. Still searching...
"Paul Ibison" wrote:

> Corey - possibly this is an incomplete service pack install as some messages
> in sysmessages are missing. You could have a look at sqlsp.log file from the
> c:\windows directory which might shed some light on any failed actions
> during the sp installation. Even if there isn't anything enlightening there
> I'd reapply the sp3a.
> HTH,
> Paul Ibison
>
>
|||Corey,
in htis case you could rebuild the master database or alternatively just add
the missing messages. To do the latter you'll need to create a linked server
to another server that has a complete master database and join to that table
(left outer join) to find the missing messages in sysmessages.
HTH,
Paul Ibison

Cant create index on view

Hi,

SQL Server 2005 (SP2) Developer edition on XP Pro

Can anyone help with setting up an indexed view? Part of the select statement calls a couple of very simple functions which are deterministic. The functions which are shown below do not perform any aggregation.

This is the error message.

Msg 8668, Level 16, State 0, Line 2
Cannot create the clustered index 'IX3_SA' on view 'XPS.dbo.SA_INDEXED' because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate function or grouping column from select list.

Function definitions:

create FUNCTION [dbo].[MonthName](@.MonthNo TINYINT)
RETURNS CHAR(3)
with schemabinding
AS
BEGIN
DECLARE @.MonthName CHAR(3)
IF @.MonthNo BETWEEN 1 AND 12 SET @.MonthName = SUBSTRING('JanFebMarAprMayJunJulAugSepOctNovDec',((@.MonthNo*3) -2),3)
RETURN ISNULL(@.MonthName,'')
END

create FUNCTION [dbo].[FinancialYear](
@.Year INT,
@.MonthNo TINYINT,
@.YearEndMonthNo TINYINT)
RETURNS INT
with schemabinding
AS
BEGIN
DECLARE @.FinancialYear INT
IF @.MonthNo <= @.YearEndMonthNo
SET @.FinancialYear = @.Year
ELSE
SET @.FinancialYear = @.Year + 1
RETURN @.FinancialYear
END

The first part of the select statement is as follows:

(SELECT
count_big(*) as CB,

dbo.FinancialYear(YR.Number,MTH.Number,YEAR_END_MONTH) AS REPORT_FINANCIAL_YEAR,
dbo.MonthName(MTH.Number) + ' ' + CAST(YR.Number AS CHAR(4)) AS REPORT_MONTH,
dbo.MonthName(YEAR_END_MONTH) + ' ' + CAST(dbo.FinancialYear(YR.Number,MTH.Number,YEAR_END_MONTH) AS CHAR(4)) AS REPORT_FINANCIAL_YEAR_END,

I can create the index on this view if I comment out the calls to the functions so I know that is where the problem is. I can't however see why this is erroring as both only return a single value without any agregation.

Anyone got any ideas on this?

Thanks in advance

David.

Well that met with a deafening silence.

The answer was to move these function calls out of the indexed view definition into a standard view that sits above it.

Can't create databases in Management Studio

I seem to be having a number of problems using managment studio (MS) against my locally installed SQL 2005 Standard Edition. E.g. when I create a default database using MS it says...

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The server could not load DCOM. (Microsoft SQL Server, Error: 7404)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=7404&LinkId=20476

However, the hyperlinks are less than helpful. I also get problems doing various maintance work from MS. I don't think its a database engine problem 'cause I can do all the work via TSQL DDL but the interface is so much easier to use (or should be). BTW it's running on XP Pro (firewall problem?).

I've also found an Event Log entry but don't know what it's asking me to enable...

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17102
Date: 06/02/2006
Time: 20:12:06
User: N/A
Computer: TITAN
Description:
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

|||

Finally sorted it out. It was the NVidia client to the motherboards Hardware Firewall that was causing the problem. I had to remove that to get IE7 working and now SQL Server is creating databases!

|||

I am getting all those exact same error messages when creating a database. My IE 7 is working just fine however. Can you tell me what you had to do to disable an nVidia motherboard hardware firewall thing? I've never heard of that, it sounds like it is worth a try at this point.

npack@.hotmail.com

|||Sure, you need to uninstall the nVidia firewall software.

Can't create databases in Management Studio

I seem to be having a number of problems using managment studio (MS) against my locally installed SQL 2005 Standard Edition. E.g. when I create a default database using MS it says...

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The server could not load DCOM. (Microsoft SQL Server, Error: 7404)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=7404&LinkId=20476

However, the hyperlinks are less than helpful. I also get problems doing various maintance work from MS. I don't think its a database engine problem 'cause I can do all the work via TSQL DDL but the interface is so much easier to use (or should be). BTW it's running on XP Pro (firewall problem?).

I've also found an Event Log entry but don't know what it's asking me to enable...

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17102
Date: 06/02/2006
Time: 20:12:06
User: N/A
Computer: TITAN
Description:
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

|||

Finally sorted it out. It was the NVidia client to the motherboards Hardware Firewall that was causing the problem. I had to remove that to get IE7 working and now SQL Server is creating databases!

|||

I am getting all those exact same error messages when creating a database. My IE 7 is working just fine however. Can you tell me what you had to do to disable an nVidia motherboard hardware firewall thing? I've never heard of that, it sounds like it is worth a try at this point.

npack@.hotmail.com

|||Sure, you need to uninstall the nVidia firewall software.

Can't Connect with Remote Sql server.

Hello All ,

I had installed Sql Server 2000 on Windows server 2003 enterprize Edition. But when I Try to connect it with Remote, 'Sql Server doesn't exists' message appears..

anybody know what may be the reason?

Moving this thread to the SQL Server forums.|||

By default, SQL Server 2005 does not allows remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps:

1.Select the SQL Server Surface Area Configuration tool from the Configuration Tools and then click Surface Area Configuration for Services and Connections option. expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply and Ok for restarting the Database engine service.

2. Try adding sqlservr.exe (present in \MSSQL\Binn directory for the default instance and \MSSQL$instance_name\Binn directory for the named instance) in the list of allowed firewall exceptions on the Windows 2003 box.

Regards,

Rajesh

|||

My question was slightly wrong..

I want to connect with sqlserver 2000 with Ip address.

-my installments are

1. Microsoft Windows Xp or window 2003 server

2 Sql Server 2000

and just want to do to connect with ip address.

I can connect to sqlserver with ip in windows2000

|||

You can connect using IP Address without any problem and for that ensure to add an entry on the client network utility on your client's machine.

Also refer to KBA http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=12&faqid=143 which helps to resolve any issues you might get.

Can't Connect with Remote Sql server.

Hello All ,

I had installed Sql Server 2000 on Windows server 2003 enterprize Edition. But when I Try to connect it with Remote, 'Sql Server doesn't exists' message appears..

anybody know what may be the reason?

Moving this thread to the SQL Server forums.|||

By default, SQL Server 2005 does not allows remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps:

1.Select the SQL Server Surface Area Configuration tool from the Configuration Tools and then click Surface Area Configuration for Services and Connections option. expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply and Ok for restarting the Database engine service.

2. Try adding sqlservr.exe (present in \MSSQL\Binn directory for the default instance and \MSSQL$instance_name\Binn directory for the named instance) in the list of allowed firewall exceptions on the Windows 2003 box.

Regards,

Rajesh

|||

My question was slightly wrong..

I want to connect with sqlserver 2000 with Ip address.

-my installments are

1. Microsoft Windows Xp or window 2003 server

2 Sql Server 2000

and just want to do to connect with ip address.

I can connect to sqlserver with ip in windows2000

|||

You can connect using IP Address without any problem and for that ensure to add an entry on the client network utility on your client's machine.

Also refer to KBA http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=12&faqid=143 which helps to resolve any issues you might get.

Can't connect to SQL Server (developer edition) from another PC?

I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
SP2 machine. It's installed without any problems.
When I try to connect to it from another XP SP2 machine (by creating
an ODBC data source) I get a Login error:
[ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed: SQLState: 08001 SQL Server Error: 17
SQL Server does not exist or access denied
I can ping the server fine from the other machine, and I've tried the
standard "sa" user/pw as welll as my own logins.
The server is configured for mixed authentication (Windows/SQL
Server).
Can anyone suggest what the problem might be?
TIA for any help
Ian
Are you running XP firewall on that machine? If so, turn it off and any
other firewall (Norton Internet Security, etc).
Chris
"ITM" <itm@.nospam.com> wrote in message
news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
> SP2 machine. It's installed without any problems.
> When I try to connect to it from another XP SP2 machine (by creating
> an ODBC data source) I get a Login error:
> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
> Connection failed: SQLState: 08001 SQL Server Error: 17
> SQL Server does not exist or access denied
> I can ping the server fine from the other machine, and I've tried the
> standard "sa" user/pw as welll as my own logins.
> The server is configured for mixed authentication (Windows/SQL
> Server).
> Can anyone suggest what the problem might be?
> TIA for any help
> Ian
|||On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:

>Are you running XP firewall on that machine? If so, turn it off and any
>other firewall (Norton Internet Security, etc).
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com.. .
>
I've tried turning off XP firewall but it made no difference. I'm not
running Norton, but am using AVG anti-virus (free edition). No other
firewall/AV software installed.
Ian
|||What happens when you telnet to port 1433 on that machine (or whatever port
you're running it on)?
Chris
"ITM" <itm@.nospam.com> wrote in message
news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
> <schmidtc@.KvalleyDotCom> wrote:
> I've tried turning off XP firewall but it made no difference. I'm not
> running Norton, but am using AVG anti-virus (free edition). No other
> firewall/AV software installed.
> Ian
|||On Sun, 20 Mar 2005 09:41:09 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:

>What happens when you telnet to port 1433 on that machine (or whatever port
>you're running it on)?
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com.. .
>
Have just downloaded and installed SP3 for SQL Server - it seems to
have done the trick. Should've tried that before :-(

Can't connect to SQL Server (developer edition) from another PC?

I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
SP2 machine. It's installed without any problems.
When I try to connect to it from another XP SP2 machine (by creating
an ODBC data source) I get a Login error:
[ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed: SQLState: 08001 SQL Server Error: 17
SQL Server does not exist or access denied
I can ping the server fine from the other machine, and I've tried the
standard "sa" user/pw as welll as my own logins.
The server is configured for mixed authentication (Windows/SQL
Server).
Can anyone suggest what the problem might be?
TIA for any help
IanAre you running XP firewall on that machine? If so, turn it off and any
other firewall (Norton Internet Security, etc).
Chris
"ITM" <itm@.nospam.com> wrote in message
news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
> SP2 machine. It's installed without any problems.
> When I try to connect to it from another XP SP2 machine (by creating
> an ODBC data source) I get a Login error:
> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
> Connection failed: SQLState: 08001 SQL Server Error: 17
> SQL Server does not exist or access denied
> I can ping the server fine from the other machine, and I've tried the
> standard "sa" user/pw as welll as my own logins.
> The server is configured for mixed authentication (Windows/SQL
> Server).
> Can anyone suggest what the problem might be?
> TIA for any help
> Ian|||On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>Are you running XP firewall on that machine? If so, turn it off and any
>other firewall (Norton Internet Security, etc).
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
>
I've tried turning off XP firewall but it made no difference. I'm not
running Norton, but am using AVG anti-virus (free edition). No other
firewall/AV software installed.
Ian|||What happens when you telnet to port 1433 on that machine (or whatever port
you're running it on)?
Chris
"ITM" <itm@.nospam.com> wrote in message
news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
> <schmidtc@.KvalleyDotCom> wrote:
>>Are you running XP firewall on that machine? If so, turn it off and any
>>other firewall (Norton Internet Security, etc).
>>Chris
>>"ITM" <itm@.nospam.com> wrote in message
>>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
> I've tried turning off XP firewall but it made no difference. I'm not
> running Norton, but am using AVG anti-virus (free edition). No other
> firewall/AV software installed.
> Ian|||On Sun, 20 Mar 2005 09:41:09 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>What happens when you telnet to port 1433 on that machine (or whatever port
>you're running it on)?
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
>> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
>> <schmidtc@.KvalleyDotCom> wrote:
>>Are you running XP firewall on that machine? If so, turn it off and any
>>other firewall (Norton Internet Security, etc).
>>Chris
>>"ITM" <itm@.nospam.com> wrote in message
>>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
>> I've tried turning off XP firewall but it made no difference. I'm not
>> running Norton, but am using AVG anti-virus (free edition). No other
>> firewall/AV software installed.
>> Ian
>
Have just downloaded and installed SP3 for SQL Server - it seems to
have done the trick. Should've tried that before :-(