Error when trying to create new databaase using SQL Server

Hi,

I have installed MS SQL server and I'm trying to create a database using the Web Matrix Project. I'm doing the following:

1. Click the Data tab in the Workspace pane.
2. Click on "Add Database Connection"
3. Select "SQL Server/MSDE Database" and click OK
4. Enter the following information:
server=localhost
Windows authentication is on
Database=somename

Click Ok

After I do all this, I get the following error:
Unable to connect to the database
SQL server does not exist or access denied.
ConnectionOpen (Connect()).

The SQL Service Manager is running with the option "Distributed Transaction Coordinator" displaying on Services. (I'm new to SQL server).

What could be causing this to happen?

Thanks a lot."Add Database Connection" is for connecting to an existing database...

use SQL Enterprise Manager to create the database first.|||1. Check if the DNS entries for the database servers are correct. These could be one of the reasons.
2. You must also see if you have sysadmin previledges to create a database.

These are some of the points that come to mind.

Error when opening Designer

When I try to open the designer (with exiting, e.g. tutorial or new project/package) I get the following error message:

Microsoft Visual Studio is unable to load this document:

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

After closing the project I have the following application event log error:

Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault address 0x014fb87c.

I had the same problem. Any ideas anyone?|||I found the answer. Reformat and reinstall everything. As far as I can tell that is the only solution.|||

Did you find a solution to this? I am experiencing the same problem and hoping that a reformat and reload is not the only path.

Thanks

Richard

Error when opening Designer

When I try to open the designer (with exiting, e.g. tutorial or new project/package) I get the following error message:

Microsoft Visual Studio is unable to load this document:

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

After closing the project I have the following application event log error:

Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault address 0x014fb87c.

I had the same problem. Any ideas anyone?|||I found the answer. Reformat and reinstall everything. As far as I can tell that is the only solution.|||

Did you find a solution to this? I am experiencing the same problem and hoping that a reformat and reload is not the only path.

Thanks

Richard

sql

Error when loading Package

Hi all,
I've finished an SSIS Package on my computer and want to move the project into production server. I was just copied the whole files and when I load the package from production server there was an error occured, the description is below :

Error 1 Error loading 'SC2DC_Regular.dtsx' : The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. . e:\dw workplace\sc2dc_server\SC2DC_Regular.dtsx 1 1

What's the problem with my Package, I never met this error before with the same behaviour of moving SSIS project from one computer to another.
Thanks in advance

Is you production server 64-bit? If so, the problem may be that your scripts are not precompiled. Make sure your PreCompileScriptIntoBinaryCode is True (the default). Scripts are compiled when the script editor IDE is closed, so you may need to open and close the scripts (tasks and components) to get them to compile.
|||The property is True and like I wrote before I moved my previous project to that production server and it's work fine. Only this current project I got this error.|||Hi all,
Does anyone know what's the real problem with my package ?|||Hi,
after searching the answer for days I found this thread :

https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1244365&SiteID=1

no wonder there's no people here tried to answered my question ;p except JayH, thanks bro :-)

sql

Error when attempting to use SQL Server Import and Export Wizard

I'm unable to use SSIS packages after installing SQL Server 2005. Specifically when I first loaded a new Integration Services project in SQL Server Business Intelligence Development Studio the default SSIS package could not load, I get Package.dtsx in my tabbed document view but in the body of this window is a error message: "Microsoft Visual Studio is unable to load this document. QI for IEnumVARIANT failed on the unmanaged server."

If I try to use the SQL Server Import and Export Wizard shortly after the window to select your data source I get a pop-up error message:

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

ADDITIONAL INFORMATION:

QI for IEnumVARIANT failed on the unmanaged server. (CustomMarshalers)

Anyone have any ideas on how I can resolve this?

I have experienced the same problem. Have you found a solution yet?

I found other users experiencing similar problems, but apparently not the same issue. I tried the fix at http://groups-beta.google.com/group/microsoft.public.dotnet.framework.setup/browse_thread/thread/a2ed96d68cb349f3/db810a1bcf8f66e4?q=qi+ienumvariant&_done=%2Fgroups%3Fhl%3Den%26lr%3Dlang_en%26safe%3Doff%26c2coff%3D1%26q%3Dqi+ienumvariant%26qt_s%3DSearch+Groups%26&_doneTitle=Back+to+Search&&d#db810a1bcf8f66e4

but had no luck.

Error when attempting to use SQL Server Import and Export Wizard

I'm unable to use SSIS packages after installing SQL Server 2005. Specifically when I first loaded a new Integration Services project in SQL Server Business Intelligence Development Studio the default SSIS package could not load, I get Package.dtsx in my tabbed document view but in the body of this window is a error message: "Microsoft Visual Studio is unable to load this document. QI for IEnumVARIANT failed on the unmanaged server."

If I try to use the SQL Server Import and Export Wizard shortly after the window to select your data source I get a pop-up error message:

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

ADDITIONAL INFORMATION:

QI for IEnumVARIANT failed on the unmanaged server. (CustomMarshalers)

Anyone have any ideas on how I can resolve this?

I have experienced the same problem. Have you found a solution yet?

I found other users experiencing similar problems, but apparently not the same issue. I tried the fix at http://groups-beta.google.com/group/microsoft.public.dotnet.framework.setup/browse_thread/thread/a2ed96d68cb349f3/db810a1bcf8f66e4?q=qi+ienumvariant&_done=%2Fgroups%3Fhl%3Den%26lr%3Dlang_en%26safe%3Doff%26c2coff%3D1%26q%3Dqi+ienumvariant%26qt_s%3DSearch+Groups%26&_doneTitle=Back+to+Search&&d#db810a1bcf8f66e4

but had no luck.

Error upon creation of Integration Services

After I aborted my installation of the tools that come with Katmai, I could not create Integration Services project nor add package to an existing project. I get the following error

Constructor on type 'Microsoft.DataTransformationServices.Wizards.EtlProjectWizardInitializer' not found.

I've removed anything that had the word 'Katmai' in Add/REmove programs. I've also reinstalled the 2005 tools. Still no luck. I'm just wondering if anyone here has encountered this error.
I guess the abort did not rollback completely, but then its just my guess.
Did you try re-installing katmai tools and do a complete un-install after that?.|||Hi sir. I did a complete uninstall of Katmai db and tools. I'll try to reinstall it again, maybe it will help. I just repaired my VS2005Pro installation thinking it can solve the problem but still no luck.
|||

[Microsoft follow-up]

Possible katmai bug here guys.

|||

This sounds like one of the known bugs for Katmai.

If this is the same issue that I'm thinking of, it's because the component which handles our project creation is pointing to the Katmai files.

In the registry, the keys under (CLSID, CurVer):

HKEY_CLASSES_ROOT\Microsoft.SqlServer.Management.UI.WizardManager

Should be the same as:

HKEY_CLASSES_ROOT\Microsoft.SqlServer.Management.UI.WizardManager.9

The values should be:

CLSID = {4503861B-5694-45AE-94DD-BC6541316FB7}

CurVer = Microsoft.SqlServer.Management.UI.WizardManager.9

If CurVer is Microsoft.SqlServer.Management.UI.WizardManager.10, then this is the issue that we've seen.

Note, I can't recommend tweaking the registry by hand... but if uninstalling SQL Server and Visual Studio doesn't fix the issue, this might be an alternative.

It's odd that you're still hitting it after uninstalling everything, but I guess aborting the installation might have left you in a bad state. I know that a number of setup related issues have been resolved since the June CTP, and hopefully the issue that put you into this state was one of them. Make sure that when you reinstall, you have no instances of Visual Studio running.

~Matt

|||Moving to the Katmai SSIS forum.|||

There is a workaround to get the SQL Server 2005 tools working when it is installed with Katmai server.

You need to update this file "<drive>:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Projects\DataTransformationsProject.vsz".

Replace the "Microsoft.SqlServer.Management.UI.WizardManager" with "Microsoft.SqlServer.Management.UI.WizardManager.9". Save the change and restart the SQL Server 2005 tools. You should be able to create the new projects.

|||This weekend, I reinstalled both my VS2005Pro and SQL2005Dev as a final brute force solution. I was hoping that this would also erase in the registry the entry key that points to the non-existing or invalid dll. I noticed that even for the supposed "fresh" install, the layout of my IDE did not change and the problem was still there.

Thanks so much for the replies guys. Feng, I will apply your solution.

|||I applied both solutions here. I don't care which one did it but the important thing is my headache is over. Thank you so much again! More power to you guys!

Error upon creation of Integration Services

After I aborted my installation of the tools that come with Katmai, I could not create Integration Services project nor add package to an existing project. I get the following error

Constructor on type 'Microsoft.DataTransformationServices.Wizards.EtlProjectWizardInitializer' not found.

I've removed anything that had the word 'Katmai' in Add/REmove programs. I've also reinstalled the 2005 tools. Still no luck. I'm just wondering if anyone here has encountered this error.
I guess the abort did not rollback completely, but then its just my guess.
Did you try re-installing katmai tools and do a complete un-install after that?.|||Hi sir. I did a complete uninstall of Katmai db and tools. I'll try to reinstall it again, maybe it will help. I just repaired my VS2005Pro installation thinking it can solve the problem but still no luck.
|||

[Microsoft follow-up]

Possible katmai bug here guys.

|||

This sounds like one of the known bugs for Katmai.

If this is the same issue that I'm thinking of, it's because the component which handles our project creation is pointing to the Katmai files.

In the registry, the keys under (CLSID, CurVer):

HKEY_CLASSES_ROOT\Microsoft.SqlServer.Management.UI.WizardManager

Should be the same as:

HKEY_CLASSES_ROOT\Microsoft.SqlServer.Management.UI.WizardManager.9

The values should be:

CLSID = {4503861B-5694-45AE-94DD-BC6541316FB7}

CurVer = Microsoft.SqlServer.Management.UI.WizardManager.9

If CurVer is Microsoft.SqlServer.Management.UI.WizardManager.10, then this is the issue that we've seen.

Note, I can't recommend tweaking the registry by hand... but if uninstalling SQL Server and Visual Studio doesn't fix the issue, this might be an alternative.

It's odd that you're still hitting it after uninstalling everything, but I guess aborting the installation might have left you in a bad state. I know that a number of setup related issues have been resolved since the June CTP, and hopefully the issue that put you into this state was one of them. Make sure that when you reinstall, you have no instances of Visual Studio running.

~Matt

|||Moving to the Katmai SSIS forum.|||

There is a workaround to get the SQL Server 2005 tools working when it is installed with Katmai server.

You need to update this file "<drive>:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Projects\DataTransformationsProject.vsz".

Replace the "Microsoft.SqlServer.Management.UI.WizardManager" with "Microsoft.SqlServer.Management.UI.WizardManager.9". Save the change and restart the SQL Server 2005 tools. You should be able to create the new projects.

|||This weekend, I reinstalled both my VS2005Pro and SQL2005Dev as a final brute force solution. I was hoping that this would also erase in the registry the entry key that points to the non-existing or invalid dll. I noticed that even for the supposed "fresh" install, the layout of my IDE did not change and the problem was still there.

Thanks so much for the replies guys. Feng, I will apply your solution.

|||I applied both solutions here. I don't care which one did it but the important thing is my headache is over. Thank you so much again! More power to you guys!

Error trying to save a date field

Hi there, right now i'm working with a VB6 project that connects to a
SQLSERVER 2000.
I discovered a problem that, i hope you can help me.
The problem is that, when i try to save a record with a date field - the
date saved in database is 2 days more that the typed date. ALWAYS 2 DAYS!!!
Don't know why.
In order to save a record to DB i try to use val = cdec(val), where val is a
date value, and for strings values i just use val = "'" & val & "'", and so
on... for diferent types of fields.
Because i'm developing for a spanish environment i decided to convert dates
in the right format ("dd/mm/yyyy") and try to have regional settings that
match national language and location.
If anybody can help me, please i will appreciate it.
Felix.You probably represent the date as some umber datatype (float, int or so) an
d the VB "base date"
differs from the SQL Server "base date" by 2 days. Never use numbers to repr
esent datetime in SQL,
represent them as strings. Or better yet, use a date datatype in your host l
anguage and use
parametized queries. Read here about datetime datatype in SQL Server:
http://www.karaszi.com/SQLServer/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Felix Quevedo C." <FelixQuevedoC@.discussions.microsoft.com> wrote in messag
e
news:3FBFD807-414F-4846-9DCE-A90AAFF1CB95@.microsoft.com...
> Hi there, right now i'm working with a VB6 project that connects to a
> SQLSERVER 2000.
> I discovered a problem that, i hope you can help me.
> The problem is that, when i try to save a record with a date field - the
> date saved in database is 2 days more that the typed date. ALWAYS 2 DAYS!!
!
> Don't know why.
> In order to save a record to DB i try to use val = cdec(val), where val is
a
> date value, and for strings values i just use val = "'" & val & "'", and s
o
> on... for diferent types of fields.
> Because i'm developing for a spanish environment i decided to convert date
s
> in the right format ("dd/mm/yyyy") and try to have regional settings that
> match national language and location.
> If anybody can help me, please i will appreciate it.
> Felix.|||Sounds like VB is converting the date to an integer and back again, and
using its own base date (1899-12-30) instead of SQL Server's (1900-01-01).
Try taking the literal string and passing it as a string. If you do this,
be sure to type in a proper format, e.g. YYYYMMDD. If you type in
mm/dd/yyyy there are several points along the way where this can easily
convert to dd/mm/yyyy.
A
"Felix Quevedo C." <FelixQuevedoC@.discussions.microsoft.com> wrote in
message news:3FBFD807-414F-4846-9DCE-A90AAFF1CB95@.microsoft.com...
> Hi there, right now i'm working with a VB6 project that connects to a
> SQLSERVER 2000.
> I discovered a problem that, i hope you can help me.
> The problem is that, when i try to save a record with a date field - the
> date saved in database is 2 days more that the typed date. ALWAYS 2
> DAYS!!!
> Don't know why.
> In order to save a record to DB i try to use val = cdec(val), where val is
> a
> date value, and for strings values i just use val = "'" & val & "'", and
> so
> on... for diferent types of fields.
> Because i'm developing for a spanish environment i decided to convert
> dates
> in the right format ("dd/mm/yyyy") and try to have regional settings that
> match national language and location.
> If anybody can help me, please i will appreciate it.
> Felix.|||thanks a lot Tibor. My problem is solved - Felix.
"Tibor Karaszi" wrote:

> You probably represent the date as some umber datatype (float, int or so)
and the VB "base date"
> differs from the SQL Server "base date" by 2 days. Never use numbers to re
present datetime in SQL,
> represent them as strings. Or better yet, use a date datatype in your host
language and use
> parametized queries. Read here about datetime datatype in SQL Server:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Felix Quevedo C." <FelixQuevedoC@.discussions.microsoft.com> wrote in mess
age
> news:3FBFD807-414F-4846-9DCE-A90AAFF1CB95@.microsoft.com...
>

Error trying to build and deploy for first time

I'm getting a timeout error when trying to deploy my SSAS project for the first time - any suggestions on where to go from here?

Error 1 OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. 0 0
Error 2 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property Address', Name of 'Property Address' was being processed. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the 'Unit Number' attribute of the 'Property Address' dimension from the 'foo' database was being processed. 0 0
Error 4 Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure. 0 0
Error 5 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property', Name of 'Property' was being processed. 0 0
Error 6 Errors in the OLAP storage engine: An error occurred while the 'Status Type ID' attribute of the 'Property' dimension from the 'foo' database was being processed. 0 0

How long time does the task take until you see the timeout error? Also, could you check network connectivity to the relational datasource? What authentication do you use?

Error sorting subform

Has anyone ever gotten this error message when sorting an Access Project subform based on an SQL table?

"column prefix [name of subform] does not match with the table name or alias used in the query".

I built a main parts form from a SQL table [Parts] using Access Project. I then added a subform [FSinvPARThistory] based on another SQL table [PartHistory] to record history for the part. The two are linked together using primary key 'ID'. I can sort the subform but then when I go to select another record on the main form I get the above error message.

Can you not sort a subform? If not, how can I prevent users from inadvertantly sorting a subform and getting the same message?

Thanks.

Open the subform and sort the resultset there.

Error sorting subform

Has anyone ever gotten this error message when sorting an Access Project subform based on an SQL table?

"column prefix [name of subform] does not match with the table name or alias used in the query".

I built a main parts form from a SQL table [Parts] using Access Project. I then added a subform [FSinvPARThistory] based on another SQL table [PartHistory] to record history for the part. The two are linked together using primary key 'ID'. I can sort the subform but then when I go to select another record on the main form I get the above error message.

Can you not sort a subform? If not, how can I prevent users from inadvertantly sorting a subform and getting the same message?

Thanks.

Open the subform and sort the resultset there.