I configure a table with FT index , but when i search the
table , nothing returned , why ?
Windows 2003 EE (Chinese Edition)
SQL Server 2k + SP3 (Chinese Edition)
1. makefile C:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQLServer\Config\noise.chs
2. start the MSSearch service with local system account.
3. connect to SQL Database with isqlw
create table docbase , the type of dcont field is image
and to store my document of word,excel,ppt,htm etc.
4. enable Fulltext of database
sp_fulltext_database 'enable'
5. create catalogs
execute
sp_fulltext_catalog 'ft_test','create','U:\minicent\FTDATA'
execute
sp_fulltext_table 'DOCBASE','create', 'ft_test','PK_DOCBASE
'
execute sp_fulltext_column 'DOCBASE' , 'DCONT' , 'add' ,
0x0804 , 'DOCTYPE'
-- language is Simplified Chinese 0x0804
execute sp_fulltext_table 'DOCBASE' , 'activate'
execute sp_fulltext_catalog 'ft_test','start_full'
EXEC sp_tableoption 'DOCBASE', 'text in row', 'ON'
EXEC sp_fulltext_table 'DOCBASE', 'Start_change_tracking'
EXEC
sp_fulltext_table 'DOCBASE', 'Start_background_updateindex'
6. put some docs of type .doc or .xls or .ppt into table
docbase by ASP.net applications
7. select kbid , doctype from docbase where freetext (
dcont , 'ChineseChars')
nothing returned. But i'm sure the content of the docs
include the 'ChineseChars' !
any adea ? thanks !
can you issue this query for me in the database you are Full Text indexing?
select FulltextCatalogProperty(N'test', N'ItemCount')
Also can you look for any messages in your event log from Microsoft Search
with an event ID of 3018 and post the text of this message here?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"rainbow" <anonymous@.discussions.microsoft.com> wrote in message
news:02be01c4b804$61ab6920$a501280a@.phx.gbl...
> I configure a table with FT index , but when i search the
> table , nothing returned , why ?
> Windows 2003 EE (Chinese Edition)
> SQL Server 2k + SP3 (Chinese Edition)
> 1. makefile C:\Program Files\Microsoft SQL
> Server\MSSQL\FTDATA\SQLServer\Config\noise.chs
> 2. start the MSSearch service with local system account.
> 3. connect to SQL Database with isqlw
> create table docbase , the type of dcont field is image
> and to store my document of word,excel,ppt,htm etc.
> 4. enable Fulltext of database
> sp_fulltext_database 'enable'
> 5. create catalogs
> execute
> sp_fulltext_catalog 'ft_test','create','U:\minicent\FTDATA'
> execute
> sp_fulltext_table 'DOCBASE','create', 'ft_test','PK_DOCBASE
> '
> execute sp_fulltext_column 'DOCBASE' , 'DCONT' , 'add' ,
> 0x0804 , 'DOCTYPE'
> -- language is Simplified Chinese 0x0804
> execute sp_fulltext_table 'DOCBASE' , 'activate'
> execute sp_fulltext_catalog 'ft_test','start_full'
> EXEC sp_tableoption 'DOCBASE', 'text in row', 'ON'
> EXEC sp_fulltext_table 'DOCBASE', 'Start_change_tracking'
> EXEC
> sp_fulltext_table 'DOCBASE', 'Start_background_updateindex'
> 6. put some docs of type .doc or .xls or .ppt into table
> docbase by ASP.net applications
> 7. select kbid , doctype from docbase where freetext (
> dcont , 'ChineseChars')
> nothing returned. But i'm sure the content of the docs
> include the 'ChineseChars' !
> any adea ? thanks !
>
|||Thanks , Cotter
1. > select FulltextCatalogProperty(N'ft_test',
N'ItemCount')
> 2
2. the 3018 message is:
The end of crawl for project <SQLServer SQL0000500005> has
been detected. The
Gatherer successfully processed 6 documents totaling 0K.
It failed to filter 0
documents. URLs could not be reached or were denied access.
3. What's the filter , How to pluggin the filter of
document (word ,excel , pdf etc )into the MS Search
Service ?
>--Original Message--
>can you issue this query for me in the database you are
Full Text indexing?
>select FulltextCatalogProperty(N'test', N'ItemCount')
>Also can you look for any messages in your event log from
Microsoft Search
>with an event ID of 3018 and post the text of this
message here?
>--
>Hilary Cotter
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>"rainbow" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:02be01c4b804$61ab6920$a501280a@.phx.gbl...
the[vbcol=seagreen]
sp_fulltext_catalog 'ft_test','create','U:\minicent\FTDATA'[vbcol=seagreen]
sp_fulltext_table 'DOCBASE','create', 'ft_test','PK_DOCBASE[vbcol=seagreen]
sp_fulltext_table 'DOCBASE', 'Start_change_tracking'[vbcol=seagreen]
sp_fulltext_table 'DOCBASE', 'Start_background_updateindex'
>
>.
>
|||rainbow,
From the below results, it does appear that at least 5 rows were
successfully FT Indexed. Did you find any other related "Microsoft Search"
or MssCi source event errors? Can I assume that the files () that were
inserted in by your ASP.NET application contained only Chinese characters
and that you issued SQL FTS queries using Chinese characters? If so, and if
the documents also contain English words, could you search on the English
words? There is a know bug ( bug# 356712) with SQL Server 2000, that
"Full-Text: sp_fulltext_column allows you to specify a language on an IMAGE
column, though it has no effect on indexing... DOC" and if you are
searching on the Chinese characters that the FTS query will fail to return
results.
Thanks,
John
"rainbow" <anonymous@.discussions.microsoft.com> wrote in message
news:115701c4ba2c$81213120$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks , Cotter
> 1. > select FulltextCatalogProperty(N'ft_test',
> N'ItemCount')
> 2. the 3018 message is:
> The end of crawl for project <SQLServer SQL0000500005> has
> been detected. The
> Gatherer successfully processed 6 documents totaling 0K.
> It failed to filter 0
> documents. URLs could not be reached or were denied access.
> 3. What's the filter , How to pluggin the filter of
> document (word ,excel , pdf etc )into the MS Search
> Service ?
>
> Full Text indexing?
> Microsoft Search
> message here?
> message
> the
> sp_fulltext_catalog 'ft_test','create','U:\minicent\FTDATA'
> sp_fulltext_table 'DOCBASE','create', 'ft_test','PK_DOCBASE
> sp_fulltext_table 'DOCBASE', 'Start_change_tracking'
> sp_fulltext_table 'DOCBASE', 'Start_background_updateindex'
|||1) ok, it looks like you have indexed at least one row, or perhaps you are
indexing two tables.
2) Is this a recent message for the pubs database?
3) the iFilter for office docs ships with win203 as part of the base
operating system so we know its there.
Can you try to index the authors table and see if you can query this. This
will help to verify that indexing is working currently. I suspect the 3018
is not a recent message. If it is a recent message indexing appears to be
working and your problem could be related to language resources.
"rainbow" <anonymous@.discussions.microsoft.com> wrote in message
news:115701c4ba2c$81213120$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks , Cotter
> 1. > select FulltextCatalogProperty(N'ft_test',
> N'ItemCount')
> 2. the 3018 message is:
> The end of crawl for project <SQLServer SQL0000500005> has
> been detected. The
> Gatherer successfully processed 6 documents totaling 0K.
> It failed to filter 0
> documents. URLs could not be reached or were denied access.
> 3. What's the filter , How to pluggin the filter of
> document (word ,excel , pdf etc )into the MS Search
> Service ?
>
> Full Text indexing?
> Microsoft Search
> message here?
> message
> the
> sp_fulltext_catalog 'ft_test','create','U:\minicent\FTDATA'
> sp_fulltext_table 'DOCBASE','create', 'ft_test','PK_DOCBASE
> sp_fulltext_table 'DOCBASE', 'Start_change_tracking'
> sp_fulltext_table 'DOCBASE', 'Start_background_updateindex'
sql
Showing posts with label edition. Show all posts
Showing posts with label edition. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
Frustrated programmer wants to create a SQL server database
SQL server 2000 (developer edition) has been installed and uninstalled
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install.
I hope this isn't a sign of what the new year is to bring...!!)
Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)
|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install.
I hope this isn't a sign of what the new year is to bring...!!)
Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)
|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)
Frustrated programmer wants to create a SQL server database
SQL server 2000 (developer edition) has been installed and uninstalled
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install
.
I hope this isn't a sign of what the new year is to bring...!!)Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install
.
I hope this isn't a sign of what the new year is to bring...!!)Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)
Frustrated programmer wants to create a SQL server database
SQL server 2000 (developer edition) has been installed and uninstalled
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install.
I hope this isn't a sign of what the new year is to bring...!!)Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)sql
(although it still ran even after it said that it was uninstalled) multiple
times. The "create database" button is grayed out and the wizard doesn't
exist.
Curious, is there a super-secret-special hand-shake/password that I should
be using to make the SQl server enterprise allow me to create a database?
Any help/insight would be greatly appreciated.
Thanks,
--Michael
(Please forgive if I sound ... frustrated. It's been 7 hours of
install/uninstall torment with absolutely no headway since the first install.
I hope this isn't a sign of what the new year is to bring...!!)Hi Michael
You don't say who you are logging in as or what tools you are using? If you
are a local administrator and log in using windows authentication then you
should be able to create a database. If you are in Enterprise Manager then
you should have the local instance registered, if not check out Books Online
regarding registering an instance in EM. Then you should be able to open the
tree up to see the Database branch under which are the master/model/tempdb
databases etc. Right Click the Database branch and see if you can create a
database from the menu options.
Failing that use Query Analyser and issue a CREATE DATABASE command, the
full syntax is in Books Online.
John
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)|||No, theres no secret thingy. However, if you have permissions to create
database, try using query analyser and CREATE DATABASE statement. If
statement fails, at least youll get an error and try to find out whats
wrong.
MC
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:B09B6D47-A94B-44B3-B1E8-AB0FCFD52936@.microsoft.com...
> SQL server 2000 (developer edition) has been installed and uninstalled
> (although it still ran even after it said that it was uninstalled)
> multiple
> times. The "create database" button is grayed out and the wizard doesn't
> exist.
> Curious, is there a super-secret-special hand-shake/password that I should
> be using to make the SQl server enterprise allow me to create a database?
> Any help/insight would be greatly appreciated.
> Thanks,
> --Michael
> (Please forgive if I sound ... frustrated. It's been 7 hours of
> install/uninstall torment with absolutely no headway since the first
> install.
> I hope this isn't a sign of what the new year is to bring...!!)sql
Frozen OLAP processing. Any ideas?
All, I am using SQL Server 2005 Developer's Edition on Windows XP Home Edition.
With the microsoft provided sample database AdventureWorksBI.msi comes with an analysis services solution called "Adventure Works DW"
Processing this solution should to produce the "Adventure Works DW" Analysis Services database.
This processing never finishes. It hangs on Processing Cube 'Customer Clusters ~MC. Specifically it hangs on Processing Partition 'Internet ~1 ~MG'. This looks like something having to do with Business Intelligence.
I am wondering if my installation "Operating System" is correct or allowable for "SQL Server 2005 Developer's Editon?
I wonder if I need to set any special security for Data Mining? As anyone had any experience with 'never finishing' Analysis Services processing.
All, opinions are welcome. I would 'like' to hear all 'possible' solutions.
Any ideas or opinions?
Thank you very much.
AIM.
Andre_Mikulec@.Hotmail.com
I was just going through my solution explorer.
I have noticed thate the cube or mining structure 'Customer Clusters' (the one that hangs and does not finish) does IS NOT SEEN IN MY Solution Explorer.
How can this not be?
Does anyone have any idea on how I could fix.
This problem.
I have installed the SQL Server Developer's Edition using my company's MSDN subscription at work.
I installed and deployed the Analysis Services sample solution "Adventure Works DW" just fine without any problems.
This is weird.
Does anyone have any idea on how to fix this.
I have installed and re-installed the AdventureworksBI.msi on my non-company problem host.
The same problem occurs. My old settings in OLAP seem that they are being kept.
I know that the security in the OLAP directories is strange.
Does anyone have any ideas on how to proceed?
Thank you very much.
AIM
Andre_Mikulec@.Hotmail.com
|||Moving to DM forum.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Frontpage & MS SQL Connection Error-Please Help
Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
Should give you a clue. One server does not trust the other BECAUSE THEY ARE
NOT IN A DOMAIN.
There is no way for the SQL server to know anything about the IIS server, it
could be anything trying to hack into the SQL Server.
I don't know how to get IIS to log into SQL using SQL authentication either
but perhaps you could post that question to an IIS newsgroup.
The other option is to add them both to a domain and set up an account on
SQL that refers to the IIS account and this time they will be authenticated
via the Domain Controller.
Nik Marshall-Blank MCSD/MCDBA
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbqhoqA4k6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
Should give you a clue. One server does not trust the other BECAUSE THEY ARE
NOT IN A DOMAIN.
There is no way for the SQL server to know anything about the IIS server, it
could be anything trying to hack into the SQL Server.
I don't know how to get IIS to log into SQL using SQL authentication either
but perhaps you could post that question to an IIS newsgroup.
The other option is to add them both to a domain and set up an account on
SQL that refers to the IIS account and this time they will be authenticated
via the Domain Controller.
Nik Marshall-Blank MCSD/MCDBA
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbqhoqA4k6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
Frontpage & MS SQL Connection Error-Please Help
Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated
This error means that the account is unknown on the SQL Server machine.
For example, suppose I create a user named User1 on computer Machine1.
Then I try to log into SQL Server on Machine2 using User1 from Machine1.
This is not possible because Machine2 has no idea about User1.
However, there is one trick you can employ to make this work, an old NTLM
trick that is used here.
If you create same user name on 2 machines with same exact password, then it
is possible for these accounts to work in this fashion (User1 from Machine1
to log into Machine2 as User1).
So in your case you need to create SQLUser on both machines with exact same
password and in theory it should work.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbmhoqAck6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated
This error means that the account is unknown on the SQL Server machine.
For example, suppose I create a user named User1 on computer Machine1.
Then I try to log into SQL Server on Machine2 using User1 from Machine1.
This is not possible because Machine2 has no idea about User1.
However, there is one trick you can employ to make this work, an old NTLM
trick that is used here.
If you create same user name on 2 machines with same exact password, then it
is possible for these accounts to work in this fashion (User1 from Machine1
to log into Machine2 as User1).
So in your case you need to create SQLUser on both machines with exact same
password and in theory it should work.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbmhoqAck6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
Frontpage & MS SQL Connection Error-Please Help
Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
Should give you a clue. One server does not trust the other BECAUSE THEY ARE
NOT IN A DOMAIN.
There is no way for the SQL server to know anything about the IIS server, it
could be anything trying to hack into the SQL Server.
I don't know how to get IIS to log into SQL using SQL authentication either
but perhaps you could post that question to an IIS newsgroup.
The other option is to add them both to a domain and set up an account on
SQL that refers to the IIS account and this time they will be authenticated
via the Domain Controller.
Nik Marshall-Blank MCSD/MCDBA
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbqhoqA4k6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
Should give you a clue. One server does not trust the other BECAUSE THEY ARE
NOT IN A DOMAIN.
There is no way for the SQL server to know anything about the IIS server, it
could be anything trying to hack into the SQL Server.
I don't know how to get IIS to log into SQL using SQL authentication either
but perhaps you could post that question to an IIS newsgroup.
The other option is to add them both to a domain and set up an account on
SQL that refers to the IIS account and this time they will be authenticated
via the Domain Controller.
Nik Marshall-Blank MCSD/MCDBA
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbqhoqA4k6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
Frontpage & MS SQL Connection Error-Please Help
Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
Should give you a clue. One server does not trust the other BECAUSE THEY ARE
NOT IN A DOMAIN.
There is no way for the SQL server to know anything about the IIS server, it
could be anything trying to hack into the SQL Server.
I don't know how to get IIS to log into SQL using SQL authentication either
but perhaps you could post that question to an IIS newsgroup.
The other option is to add them both to a domain and set up an account on
SQL that refers to the IIS account and this time they will be authenticated
via the Domain Controller.
--
Nik Marshall-Blank MCSD/MCDBA
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbqhoqA4k6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
Should give you a clue. One server does not trust the other BECAUSE THEY ARE
NOT IN A DOMAIN.
There is no way for the SQL server to know anything about the IIS server, it
could be anything trying to hack into the SQL Server.
I don't know how to get IIS to log into SQL using SQL authentication either
but perhaps you could post that question to an IIS newsgroup.
The other option is to add them both to a domain and set up an account on
SQL that refers to the IIS account and this time they will be authenticated
via the Domain Controller.
--
Nik Marshall-Blank MCSD/MCDBA
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbqhoqA4k6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
Frontpage & MS SQL Connection Error-Please Help
Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated
If you are not on a domain your best bet is probably to use SQL
Authentication. You will pass a user name and password from the web page to
SQL Server.
Keith
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbihoqAZk6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
|||I meant to mention in my previous post that you can look up connection
string examples on www.connectionstrings.com
Keith
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbihoqAZk6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
sql
are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
Through OBDC (System DSN) I created a connection to the SQL db. Then on
my laptop I opened up frontpage to create a page to view the db results.
But, I get the this error when I select the "System Data Source on Web
Server":
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I have been browsing through the web for some time now and can not seem
to get a direct resolution to this error.
On the SQL Server Management under Logins I have selected "Windows
Authentication", I have added the IIS_WPG, created a new account named
SQLUSER, etc..
Nothing seems to work. Every solution I have found so far on the web has
to do with another application, most often it seems it is a .net issue.
Basically I am trying to create forms via Frontpage to input and view
data entered into a SQL db.
Any help will be very much appriciated
If you are not on a domain your best bet is probably to use SQL
Authentication. You will pass a user name and password from the web page to
SQL Server.
Keith
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbihoqAZk6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
|||I meant to mention in my previous post that you can look up connection
string examples on www.connectionstrings.com
Keith
"Sam White" <noSPAM@.Please.com> wrote in message
news:wuCdnbihoqAZk6beRVn-3g@.giganews.com...
> Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are
> NOT in a domain. The second server has SQL 2000, the first has IIS 6.0
> Through OBDC (System DSN) I created a connection to the SQL db. Then on my
> laptop I opened up frontpage to create a page to view the db results. But,
> I get the this error when I select the "System Data Source on Web Server":
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"
> I have been browsing through the web for some time now and can not seem to
> get a direct resolution to this error.
> On the SQL Server Management under Logins I have selected "Windows
> Authentication", I have added the IIS_WPG, created a new account named
> SQLUSER, etc..
> Nothing seems to work. Every solution I have found so far on the web has
> to do with another application, most often it seems it is a .net issue.
> Basically I am trying to create forms via Frontpage to input and view data
> entered into a SQL db.
> Any help will be very much appriciated
sql
Monday, March 19, 2012
From Developers edition to Enterprise?
Hi,
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.
Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
|||Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.
Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
|||Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
From Developers edition to Enterprise?
Hi,
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
From Developers edition to Enterprise?
Hi,
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
I have SQL Server 2000 Developers Edition installed and have to change it to
Enterprise edition.
Can I install the Enterprise edition just over the Developers, or does this
need an un-install first?
Thanks.Personally, I would detach your user databases, uninstall Developer, install
Enterprise, then re-attach. You'll have to reconfigure jobs and logins.
The upgrade is supported, AFAIK, however I have read about many problems...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:umVAsIUXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have SQL Server 2000 Developers Edition installed and have to change it
to
> Enterprise edition.
> Can I install the Enterprise edition just over the Developers, or does
this
> need an un-install first?
> Thanks.
>
Friday, February 24, 2012
Free ebook Download
I registered SQL Server Express and was told that I could download the Ebook Microsoft? SQL Server? 2005 Express Edition eBook. When I go to the portal, it gives me a message that it cannot be downloaded (the site cannot be found. Can someone tell me how to download this book? Thanks in advance.
You download the book from the Benefits portal, if there was an error, it was likely an intermitent thing, you should try again. It's also possible that you have a bad link, but you didn't provide the link you were using, so I can't tell. Try accessing the benefits portal via https://connect.microsoft.com/site/sitehome.aspx?SiteID=40, which should ask you to login, and then see if the download works.
Mike
|||HI Mike,
The site I was trying to download from was FTP_TK2.ds.microsoft.com. Still cannot get the document. Any ideas?
|||For good measure, I just logged into the site and attempted to download the book. It came down without a hitch, which tells me that it's not an issue with the download going wonky, which can happen sometimes. The issue must be something related to you specific situation.
Please verify that you were able to log into the Connect site and get to the benefits portal download page. If you are able to do that successfully, please give me the exact steps you are following from that page, when you get the error and the text of the error you're getting.
You may also want to seek help directly from the Connect Support group by submitting a question at https://connect.microsoft.com/Main/ContactUs/EmailSupport.aspx?Category=3.
Mike
|||Same thing happens to me when I register for the benefits, and click the link in the email labeled "Registration Benefit Portal".It takes me to the MS Connect site with a 404 of:
Page Not Found
The content that you requested cannot be found or you do not have permission to view it.
If you believe you have reached this page in error, click the Contact Us link at the bottom of the page to report the issue and include this ID in your e-mail: 92156a33-0571-4fee-9031-4642f9c59122
|||
click this link --> https://connect.microsoft.com/site/sitehome.aspx?SiteID=40
And tell me what happens.
Mike
|||Mike,
I got a 404 at 12:23 am PDT on Sep 6, 2007.
I'm guessing that one must be logged into the connect site first. (I'll try that next.)
|||I recommend http://bookilook.com -> ebook search website.
|||Though is not what you have asked for but here are some good resource - material on SQL Server that you can refer as Begginner / DBA http://hemantgirisgoswami.blogspot.com/2007/08/resource-for-new-sql-server-dba-and.html
Free ebook Download
I registered SQL Server Express and was told that I could download the Ebook Microsoft? SQL Server? 2005 Express Edition eBook. When I go to the portal, it gives me a message that it cannot be downloaded (the site cannot be found. Can someone tell me how to download this book? Thanks in advance.
You download the book from the Benefits portal, if there was an error, it was likely an intermitent thing, you should try again. It's also possible that you have a bad link, but you didn't provide the link you were using, so I can't tell. Try accessing the benefits portal via https://connect.microsoft.com/site/sitehome.aspx?SiteID=40, which should ask you to login, and then see if the download works.
Mike
|||HI Mike,
The site I was trying to download from was FTP_TK2.ds.microsoft.com. Still cannot get the document. Any ideas?
|||For good measure, I just logged into the site and attempted to download the book. It came down without a hitch, which tells me that it's not an issue with the download going wonky, which can happen sometimes. The issue must be something related to you specific situation.
Please verify that you were able to log into the Connect site and get to the benefits portal download page. If you are able to do that successfully, please give me the exact steps you are following from that page, when you get the error and the text of the error you're getting.
You may also want to seek help directly from the Connect Support group by submitting a question at https://connect.microsoft.com/Main/ContactUs/EmailSupport.aspx?Category=3.
Mike
|||Same thing happens to me when I register for the benefits, and click the link in the email labeled "Registration Benefit Portal".It takes me to the MS Connect site with a 404 of:
Page Not Found
The content that you requested cannot be found or you do not have permission to view it.
If you believe you have reached this page in error, click the Contact Us link at the bottom of the page to report the issue and include this ID in your e-mail: 92156a33-0571-4fee-9031-4642f9c59122
|||
click this link --> https://connect.microsoft.com/site/sitehome.aspx?SiteID=40
And tell me what happens.
Mike
|||Mike,
I got a 404 at 12:23 am PDT on Sep 6, 2007.
I'm guessing that one must be logged into the connect site first. (I'll try that next.)
|||I recommend http://bookilook.com -> ebook search website.
|||Though is not what you have asked for but here are some good resource - material on SQL Server that you can refer as Begginner / DBA http://hemantgirisgoswami.blogspot.com/2007/08/resource-for-new-sql-server-dba-and.html
Free ebook Download
I registered SQL Server Express and was told that I could download the Ebook Microsoft? SQL Server? 2005 Express Edition eBook. When I go to the portal, it gives me a message that it cannot be downloaded (the site cannot be found. Can someone tell me how to download this book? Thanks in advance.
You download the book from the Benefits portal, if there was an error, it was likely an intermitent thing, you should try again. It's also possible that you have a bad link, but you didn't provide the link you were using, so I can't tell. Try accessing the benefits portal via https://connect.microsoft.com/site/sitehome.aspx?SiteID=40, which should ask you to login, and then see if the download works.
Mike
|||HI Mike,
The site I was trying to download from was FTP_TK2.ds.microsoft.com. Still cannot get the document. Any ideas?
|||For good measure, I just logged into the site and attempted to download the book. It came down without a hitch, which tells me that it's not an issue with the download going wonky, which can happen sometimes. The issue must be something related to you specific situation.
Please verify that you were able to log into the Connect site and get to the benefits portal download page. If you are able to do that successfully, please give me the exact steps you are following from that page, when you get the error and the text of the error you're getting.
You may also want to seek help directly from the Connect Support group by submitting a question at https://connect.microsoft.com/Main/ContactUs/EmailSupport.aspx?Category=3.
Mike
|||Same thing happens to me when I register for the benefits, and click the link in the email labeled "Registration Benefit Portal".It takes me to the MS Connect site with a 404 of:
Page Not Found
The content that you requested cannot be found or you do not have permission to view it.
If you believe you have reached this page in error, click the Contact Us link at the bottom of the page to report the issue and include this ID in your e-mail: 92156a33-0571-4fee-9031-4642f9c59122
|||
click this link --> https://connect.microsoft.com/site/sitehome.aspx?SiteID=40
And tell me what happens.
Mike
|||Mike,
I got a 404 at 12:23 am PDT on Sep 6, 2007.
I'm guessing that one must be logged into the connect site first. (I'll try that next.)
|||I recommend http://bookilook.com -> ebook search website.
|||Though is not what you have asked for but here are some good resource - material on SQL Server that you can refer as Begginner / DBA http://hemantgirisgoswami.blogspot.com/2007/08/resource-for-new-sql-server-dba-and.html
Free ebook Download
I registered SQL Server Express and was told that I could download the Ebook Microsoft? SQL Server? 2005 Express Edition eBook. When I go to the portal, it gives me a message that it cannot be downloaded (the site cannot be found. Can someone tell me how to download this book? Thanks in advance.
You download the book from the Benefits portal, if there was an error, it was likely an intermitent thing, you should try again. It's also possible that you have a bad link, but you didn't provide the link you were using, so I can't tell. Try accessing the benefits portal via https://connect.microsoft.com/site/sitehome.aspx?SiteID=40, which should ask you to login, and then see if the download works.
Mike
|||HI Mike,
The site I was trying to download from was FTP_TK2.ds.microsoft.com. Still cannot get the document. Any ideas?
|||For good measure, I just logged into the site and attempted to download the book. It came down without a hitch, which tells me that it's not an issue with the download going wonky, which can happen sometimes. The issue must be something related to you specific situation.
Please verify that you were able to log into the Connect site and get to the benefits portal download page. If you are able to do that successfully, please give me the exact steps you are following from that page, when you get the error and the text of the error you're getting.
You may also want to seek help directly from the Connect Support group by submitting a question at https://connect.microsoft.com/Main/ContactUs/EmailSupport.aspx?Category=3.
Mike
|||Same thing happens to me when I register for the benefits, and click the link in the email labeled "Registration Benefit Portal".It takes me to the MS Connect site with a 404 of:
Page Not Found
The content that you requested cannot be found or you do not have permission to view it.
If you believe you have reached this page in error, click the Contact Us link at the bottom of the page to report the issue and include this ID in your e-mail: 92156a33-0571-4fee-9031-4642f9c59122
|||
click this link --> https://connect.microsoft.com/site/sitehome.aspx?SiteID=40
And tell me what happens.
Mike
|||Mike,
I got a 404 at 12:23 am PDT on Sep 6, 2007.
I'm guessing that one must be logged into the connect site first. (I'll try that next.)
|||I recommend http://bookilook.com -> ebook search website.
|||Though is not what you have asked for but here are some good resource - material on SQL Server that you can refer as Begginner / DBA http://hemantgirisgoswami.blogspot.com/2007/08/resource-for-new-sql-server-dba-and.html
free distribution of "Database Engine"
Hi:
I'm an asp.net programmer and my database is in access format.
My server is Windows Server 2003 Enterprise Edition Service Pack 1.
I do not need microsoft access installed on my server to access my database through asp.net.
I want migrate my database to sql server 2005
Could I access my database in sql server 2005 format (mdf) through asp.net without sql server 2005 installed on the server?
could I buy to microsoft only "Database Engine"? or
Is there a free distribution of "Database Engine"?
Thanks!!
There is a free version of SQL Server 2005, SQL Server Express..
http://msdn.microsoft.com/vstudio/express/sql/
The data does need to be on some machine somewhere with SQL Server installed.
|||Hi,
You do not need Access installed on the server, only the runtime (which I think ships with Windows these days, at the very worst the runtime is freely distributable if you have VSTO). You should take a look at SQL Server 2005 Express edition (http://msdn.microsoft.com/vstudio/express/sql/download/). Free, and as easy (or easier) to use as Access.
Hope this helps.
Subscribe to:
Posts (Atom)